[thelist] SQL Date formating

Christopher Ditty cditty at mlgw.org
Tue Feb 11 10:02:09 CST 2003


Can someone point me in the right direction with formating dates in
mysql query statements?  I am trying to format 12/01/2002 in a mysql
statement when I do a select.  The end result should be 2002-12-01.

This is the sql statement I am using.
SELECT *
FROM 100420_gmtr_t
where read_date like 'DATE_FORMAT(12/01/2002, %Y-%m-%d)%'

According to the mysql documentation, this should be working but it is
not.

Chris




More information about the thelist mailing list