[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