Convert date format

[Ifoel]

Hai All,

Im beginer in Mysql.
I have field's Date in MySql, with format "dd/mm/yyyy hh:mm:ss".
How to Select it and format change like this "yyyy-mm-dd hh:mm:ss"?



Date
04/07/2007 21:23:37

Change to

Date
2007-07-04 21:23:37

how to works

thanks in advance

[hariharanmca]

Hai All,

Im beginer in Mysql.
I have field's Date in MySql, with format "dd/mm/yyyy hh:mm:ss".
How to Select it and format change like this "yyyy-mm-dd hh:mm:ss"?



Date
04/07/2007 21:23:37

Change to

Date
2007-07-04 21:23:37

how to works

thanks in advance

(do not double post your query).

you have to post your front-end and back-end with version.
i think this will help you Click Here

[Ifoel]

Oke Hari..
I dont mean it..

thanks for your reply