Now() Format

coxdabd · January 31, 2011, 11:04am

Hi all, is it possible to format the way now() enters the format of the date and time into the database. It’s going in as 2011-01-31 11:03. I want it to ideally be 31-01-2011 11:03. Any help is appreciated as always

DarthGuido · January 31, 2011, 11:08am

In doesn’t enter that way in the database at all. It’s just the way the database shows the value to you.
You can change the way it is presented to you using date_format

coxdabd · January 31, 2011, 11:14am

Hi guido, I’ve just tried formatting the date as my below example but now nothing is showing…?

<?php echo date_format($orders['date_added'],'%b %d %Y %h:%i %p') ?>

DarthGuido · January 31, 2011, 11:15am

date_format is a MySQL function…

coxdabd · January 31, 2011, 11:21am

Right ok, so I need to use that function when entering data to the database?

logic_earth · January 31, 2011, 11:25am

No, when you pull it out of the database.

coxdabd · January 31, 2011, 11:26am

Hey dude, could you possibly show me an example of how this is done? Cheers

logic_earth · January 31, 2011, 11:27am


SELECT data_format( DateField, ... ) FROM testtable

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

coxdabd · January 31, 2011, 11:34am

Massive help thanks, is there any I can incorporate this into a SELECT * FROM table as this is what I have used. Though I don’t think that’s best practice?

DarthGuido · January 31, 2011, 11:43am

Don’t use the *

coxdabd · January 31, 2011, 11:49am

Okey dokey Thank you both for your help and advice.