| 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 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.
Description: 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().