Date formatting and conversion

[sknyppy]

I have a datetime field that contains the value
"2002-08-15 13:00:00" but when I display the variable or try to copy it to another table it automatically converts to this format: "8/15/2002 1:00:00 PM".

How can I retain the initial formatting of the value when I display or copy this value?

I'm using mySQL/ASP for database and programming.

Thanks,
Dave

 

[piti]

try the date_format function

SELECT DATE_FORMAT(datefield, '%Y-%m-%d %H:%i:%S') FROM tablename

INSERT INTO to_table SELECT DATE_FORMAT(datefield, '%Y-%m-%d %H:%i:%S') FROM from_table

but i'm not sure if mysql displays after insert the date in this format :-(