HomeFlySpeed SQL Querydate formate for mysql

date formate for mysql


i am using mysql and where i have date value is datestamp how can i change to dd-mm-yyyy when i run query
Ritesh Mehta | email
February 18 2009, 12:11 PM
Dear Ritesh,

Unfortunately, it is not possible to change the view of timestamp columns. You may change it by converting your timestamp column to date: Date(MyTimestampColumnName), but result dataset will be read-only in this case.
Sergey Smagin | email
1 day, 16 hours since original post
This topic is closed