Timestamp format

[fluxdemon]

I would like to remove the output format from a timestamp field. e.g. 20040526124015 instead of 5/26/2004 12:40:15 PM

Thanks in advance

 

[sleipnir214]

Have you looked at MySQL's date_format() function?



Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[TonyGroves]

The default output format of a TIMESTAMP field is yyyymmddhhmmss, so you don't need to do anything to it. For a DATETIME field, you could simply use SELECT datetimefield+0 to get your desired output.

-----
ALTER world DROP injustice, ADD peace;

 

[fluxdemon]

Like select id+0,description,url from ...?