Kevin Day writes:
This worked in 4.0:
mysql> SELECT CONVERT(NOW(), DATE);
+----------------------+
| CONVERT(NOW(), DATE) |
+----------------------+
| 2004-01-16 18:12:18 |
+----------------------+
1 row in set (0.00 sec)
And even in 4.1.0, but in 4.1.1 it returns:
mysql> SELECT CONVERT(NOW(), DATE);
ERROR 1064: You have an error in your SQL syntax. Check the manual
that corresponds to your MySQL server version for the right syntax to
use near ')' at line 1
Thank you so much for your bug report.
It helped us fix a bug in 4.1.2.
This is actually a bug in bison (parser generator). We have found a
workaround and will apply it in 4.1.2, which should be out in few
weeks.
Thanks again.
--
Sincerely,
Want to swim with the dolphins? (April 14-16, 2004)
http://www.mysql.com/uc2004/
2 messages in com.mysql.lists.bugsRe: CONVERT() broken in 4.1.1?
