>>>> 2012/02/04 19:13 -0800, Rajeev Prasad >>>>
MySQL datetime field type keeps data as: YYYY-MM-DD HH:mm:SS is there a way to 
store this data as: YYYY/MM/DD HH:mm:SS or going much further (optionally) can 
we store as: MM/DD/YYYY HH:mm:SS  ?   if not then whats the best way to 
reformat the cell value from YYYY-MM-DD to MM/DD/YYY 
<<<<<<<<
That is MySQL s string format, and that is what you get. That said, there is a 
function DATE_FORMAT (look it up) that lets one change its look. Its format 
argument is quite ugly.


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql

Reply via email to