Bug #13954 Cant use DATE()
Submitted: 12 Oct 2005 8:32 Modified: 12 Oct 2005 10:00
Reporter: Hans Kejser Hansen Email Updates:
Status: Not a Bug Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:MySQL 4.0.23 & MySQL 4.0.24 OS:Linux (Debian 3.1)
Assigned to: CPU Architecture:Any

[12 Oct 2005 8:32] Hans Kejser Hansen

Everytime I try to use DATE(), i got a "ERROR 1064: You have an error in your SQL syntax.  Check the manual............." in return.

Even the example from the documentation SELECT DATE('2003-12-31 01:02:03'); wont work

I try it from a PHP script, PhpMyAdmin and the mysql prompt.

How to repeat:
SELECT DATE('2003-12-31 01:02:03');

And everything else where I use DATE().
[12 Oct 2005 10:00] Alexander Keremidarski
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

DATE() function was introduced in 4.1

Use DATE_FORMAT() instead
[12 Oct 2005 10:19] Hans Kejser Hansen
OK thanks.

I don't know where You have the information "DATE() function was introduced in 4.1" from
But it would be really nice, if this kind of information was together with the function description, in this case at http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html

Take fx. a look t the PHP documentation.