now() Format

[coxdabd]

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

[guido2004]

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]

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') ?>

[guido2004]

date_format is a MySQL function...

[coxdabd]

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

[logic_earth]

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

No, when you pull it out of the database.

[coxdabd]

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

[logic_earth]

SELECT data_format( DateField, ... ) FROM testtable

As posted above: http://dev.mysql.com/doc/refman/5.1/...on_date-format

[coxdabd]

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?

[guido2004]

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?

Don't use the *

[coxdabd]

Okey dokey Thank you both for your help and advice.