Bug #14462 DATE(...), TIME(...) functions do not work

• Submitted: 29 Oct 2005 11:43
• Modified: 29 Oct 2005 16:19
• Reporter: Stoyan Kostadinov
• Status: Can't repeat
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.0.15
• OS: Windows (Windows XP)
• CPU Architecture: Any

[29 Oct 2005 11:43] Stoyan Kostadinov

Description:
SELECT DATE('2003-12-31 01:02:03'); does not work.
Neither does: 
SELECT TIME('2003-12-31 01:02:03');

How to repeat:
Just copy-paste the SELECT DATE, SELECT TIME example from the documentation
in a mysql client and you are done.

Suggested fix:
Install PostgreSQL or anything else that works :). Sorry for the flame but I desperately needed this functions to work out of the box as shown in the documentation. Either fix the documentation or the bug itself.

[29 Oct 2005 16:19] Valeriy Kravchuk

Sorry, but I can't repeat the behaviour you described:

C:\Documents and Settings\openxs>mysql -u root -P3307 -p
Enter password: ****
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 11 to server version: 5.0.15-nt

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT DATE('2003-12-31 01:02:03');
+-----------------------------+
| DATE('2003-12-31 01:02:03') |
+-----------------------------+
| 2003-12-31                  |
+-----------------------------+
1 row in set (0.04 sec)

mysql> SELECT TIME('2003-12-31 01:02:03');
+-----------------------------+
| TIME('2003-12-31 01:02:03') |
+-----------------------------+
| 01:02:03                    |
+-----------------------------+
1 row in set (0.01 sec)