Register Date
#7

Quote:
Originally Posted by Konstantinos
Посмотреть сообщение
DATE_FORMAT can be used in queries to select the date and time with a format you apply. For example:
PHP код:
"SELECT DATE_FORMAT(register_date,'%W, %e %M %Y %r') AS date_time FROM players WHERE Name='Maro06';" 
That would return (let's say register_date has the timestamp of few seconds ago): Monday, 25 May 2015 06:57:35 PM

Keep in mind that you'll have to use % sign twice in format or mysql_format functions (PAWN).
I am sorry but I am really confused.

Can someone tell me where to put this and how?
Reply


Messages In This Thread
Register Date - by Joe70701 - 25.05.2015, 14:11
Re: Register Date - by Vince - 25.05.2015, 14:19
Re: Register Date - by Ghazal - 25.05.2015, 14:46
Re: Register Date - by Konstantinos - 25.05.2015, 14:53
Re: Register Date - by Ghazal - 25.05.2015, 15:44
Re: Register Date - by Konstantinos - 25.05.2015, 15:51
Re: Register Date - by Ghazal - 25.05.2015, 17:49
Re: Register Date - by Konstantinos - 25.05.2015, 18:38
Re: Register Date - by Ghazal - 25.05.2015, 19:35
Re: Register Date - by Konstantinos - 25.05.2015, 19:54

Forum Jump:


Users browsing this thread: 2 Guest(s)