Formatting Dates

[Anon]

Hi,
I have a date in a MySQL table.
I insert the date into the filed with CURDATE(), is there a better way?

How can I format this date into i.e. 28/06/00 00:00?

Also, what would be the best data type to use in MySQL?

Thanks,

Jord

[Anon]

define,
$date = date( "d/m/y H:i:s" );

and use $date in your INSERT...

[Anon]

Thanks for your help but which datatype should I use?

Also, the date returns the wrong time, my hosting is based in the US and I'm in the UK, How can I adjust so that it uses a UK date?

Cheers,

Jord