[SQL] Select CURDATE and format it

Zack771 · **Author**

Hi,

In one of my plugin i need to select current date, so i've made a SQL_Query(db,"SELECT CURDATE()+0") to fetch a number.

What i want is to get the actual day and the SQL value return a date in the format AAAADDMM so in order to get the DD i've try this, can you tell me if it's good or wrong (if it's wrong what does i need to do please) ?

PHP Code:


			
new dateInt = SQL_FetchInt(hQuery,0); //initial fetch value from the SQL_Query
new Float:dateFloat = float(dateInt)/10000.0;
new Float:dateFloat2 = FloatFraction(dateFloat);
new Float:dateFloatFin = RoundToFloor(dateFloat2/100.0);
if(dateFloatFin==1) { //if it's the first day of the month
//some stuff
}

Thanks by advance

Impact123 · *Last edited by Impact123; 06-17-2014 at 14:19.*

Your code is completely insane, I'll therefore skip the suggestions.
This should be what you want

PHP Code:


			
SELECT DATE_FORMAT(CURRENT_DATE(), '%Y%d%m') currentDate

If you just want the current day of the month, this should do

PHP Code:


			
SELECT DAY(CURRENT_DATE()) AS currentDay

I just want to remind you that you don't really have to use your database to get the current day.

This is one way to get the current day in sourcepawn

PHP Code:


			
decl String:sTime[3];
FormatTime(sTime, sizeof(sTime), "%d");
new currentDay = StringToInt(sTime);

Powerlord · *Last edited by Powerlord; 06-17-2014 at 17:33.*

...you are aware that SourceMod has a GetTime() function to return the current UNIX timestamp and a FormatTime timestamps look nice and pretty?

As a reminder, UNIX timestamps have no timezone information and are just the number of seconds since January 1, 1970 00:00:00 UTC. If you're getting the wrong timestamps back from your server, adjust cfg/sourcemod/sourcemod.cfg's sm_time_adjustment cvar.

Zack771 · *Last edited by Zack771; 06-18-2014 at 05:54.*

Quote:

Originally Posted by Impact123

Your code is completely insane, I'll therefore skip the suggestions.
This should be what you want

PHP Code:


			
SELECT DATE_FORMAT(CURRENT_DATE(), '%Y%d%m') currentDate

If you just want the current day of the month, this should do

PHP Code:


			
SELECT DAY(CURRENT_DATE()) AS currentDay

I just want to remind you that you don't really have to use your database to get the current day.

This is one way to get the current day in sourcepawn

PHP Code:


			
decl String:sTime[3];
FormatTime(sTime, sizeof(sTime), "%d");
new currentDay = StringToInt(sTime);

Yeah i know it's insane, it's why i'm asking here for suggestions ^^'

Thanks you for SQL query, i did not know that those "functions" exist.

For the FormatTime function, i think you forgot to add GetTime() :

PHP Code:


			
FormatTime(sTime, sizeof(sTime), "%d");

should be :

PHP Code:


			
FormatTime(sTime, sizeof(sTime), "%d",GetTime());

?

Quote:

Originally Posted by Powerlord

...you are aware that SourceMod has a GetTime() function to return the current UNIX timestamp and a FormatTime timestamps look nice and pretty?

As a reminder, UNIX timestamps have no timezone information and are just the number of seconds since January 1, 1970 00:00:00 UTC. If you're getting the wrong timestamps back from your server, adjust cfg/sourcemod/sourcemod.cfg's sm_time_adjustment cvar.

I know the GetTime() function but not FormatTime.
Thanks i'm gonna use the sourcemod way (like Impact123 show it).

Powerlord · 06-18-2014 , 09:08 Re: [SQL] Select CURDATE and format it

Quote:

Originally Posted by Zack771

For the FormatTime function, i think you forgot to add GetTime() :

PHP Code:


			
FormatTime(sTime, sizeof(sTime), "%d");

should be :

PHP Code:


			
FormatTime(sTime, sizeof(sTime), "%d",GetTime());

?

The timestamp argument is optional and the current timestamp is used if you don't provide one.

Zack771 · 06-18-2014 , 14:34 Re: [SQL] Select CURDATE and format it

Quote:

Originally Posted by Powerlord

The timestamp argument is optional and the current timestamp is used if you don't provide one.

Ok thanks for help