StewardManscat
12-17-2005, 10:34 AM
Not using PHP code here, just looking at my data roughly via phpMyAmin...
The way I read the SQL manual, I ought to be able to type
SELECT * from table WHERE dateline > DATE('2005-12-16 00:00:00')
... but mysql seems unhappy with this (syntax error).
Ideally I'd like to see the date in a human format too. Maybe (guessing here) something like:
SELECT dateline AS date('Y-M-D') from table WHERE dateline > DATE('2005-12-16 00:00:00')
I have looked at the SQL site/docs and am still not getting it.
mysql 4.0.15
phpMyAdmin 2.4.0
Any links or examples much appreciated. Thanks in advance.
The way I read the SQL manual, I ought to be able to type
SELECT * from table WHERE dateline > DATE('2005-12-16 00:00:00')
... but mysql seems unhappy with this (syntax error).
Ideally I'd like to see the date in a human format too. Maybe (guessing here) something like:
SELECT dateline AS date('Y-M-D') from table WHERE dateline > DATE('2005-12-16 00:00:00')
I have looked at the SQL site/docs and am still not getting it.
mysql 4.0.15
phpMyAdmin 2.4.0
Any links or examples much appreciated. Thanks in advance.