SQL syntax using dateline fields and DATE in phpMyAdmin ?

[StewardManscat]

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.

[sabret00the]

check this out

http://uk2.php.net/manual/en/function.mktime.php