Formatting dates

[JOBARAM]

Hi,
I created a big Mysql database that includes dates values.
I need to convert all dates to a specific format.
Can I do it through Alter Table ? How can I change all Dates format if not?
Thanks
Yossi

 

[r937]

if the datatype of the date column is datetime, you should not attempt to change it, but rather, use the DATE_FORMAT() function to display the date in the format you want


rudy

 

[JOBARAM]

Yes I have noticed Mysql has only one format to enter Dates.
Tanks for the tip.

 

[r937]

actually, mysql has many formats for entering dates, and is rather quite forgiving

see

http://www.mysql.com/doc/en/DATETIME.html

rudy