datetime field formatting question...

[rgermain]

Hey,
Quick question:

Does anyone know how to format a mysql datetime stamp while still retrieving all the other fields without haveing to type them all out in the query or writting a seperate query for it?

Never had to deal with the datetime field yet.

[SD-Syndicate]

Hi,

What I used was

<?php echo strftime("%c",$row_Test['reg_date']); ?>

The above will be displayed as :- Thu Sep 16 18:18:52 2004

You can have a look on this page for more variations 🙂

http://www.php.net/strftime

[alvinkoh]

Hi rgermain,

If you are referring to letting mysql do the date formatting of the fetched data, you can also check out the mysql DATE_FORMAT()function.

It behaves somewhat like the PHP:date() function.

Also, when dealing with DATE_FORMAT() function, you often need to convert the your field into a Unix time, so do check out UNIX_TIMESTAMP as well.

Example from mysql docs:

SELECT DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y');
-> 'Saturday October 1997'

Cheers.