formatting mysql timestamp

[Vivid Lust]

Any ideas how I can turn "2010-10-20 19:10:56" to 20th October 2010, 19:10

 

Thanks lots guys,

 

Jake

[schilly]

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

[Vivid Lust]

I'm getting Warning: sprintf() [function.sprintf]: Too few arguments in /furanet/sites/l...../web/htdocs/admin/index.php on line 72

Query was empty

[schilly]

post your code.

 

with sprintf you need to escape any % signs because it thinks you are inserting a value there so for date_format you need %%b %%d, %%y for the format.

[Vivid Lust]

$query_Recordset2 = sprintf('SELECT DATE_FORMAT(inicio,"%H:%i") FROM juegos_sesiones WHERE usuarioID = '.$lastOnline[$counter].' ORDER BY sesionID DESC LIMIT 1');

[schilly]

why are you using sprintf without inserting any values into it?

[Vander]

I would like to suggest that if possible, you convert to using INT(11) feilds and use UNIX_TIMESTAMP, a UNIX timestamp can be changed into any format you want using the PHP date() function.

Yes, the days of UNIX timestamps are limited, but that's nothing to worry about until like 2038 or something, so there's plenty of time, and even by then there will probably be new languages and your site would be long gone down the infinate shitter of the internet. XD

 

But aye, I hope this helps,

Alan.

[schilly]

Why would you use PHP to do date conversion when MySQL can do it for you?

[Vander]

Why would you use PHP to do date conversion when MySQL can do it for you?

 

Umm... Well when I'm working with MySQL, I tend to use PHP as the front end, shit just seems easier to me?

Everyone has their own wee methods of coding and shit. XD

[PFMaBiSmAd]

Doing the conversion in the query is at least 8x faster than doing it using php code. Kind of important if you have a lot of data being retrieved or you need your site to to handle a large number of visitors.

[schilly]

Umm... Well when I'm working with MySQL, I tend to use PHP as the front end, shit just seems easier to me?

Everyone has their own wee methods of coding and shit. XD

 

I use to think that until I found out about the MySQL Date Time Functions: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html