Hello everyone, Im running MySQL version 11.15 Distribution 3.23.47 on
Windows 2000. I'm having issues with the CAST command, for example, if
I execute:
CREATE TABLE new_table SELECT CAST('2000-01-01' AS DATE);
I receive the error:
ERROR 1064: You have an error in your SQL syntax near '('2000-01-01' AS
DATE)' at line 1
This create command is the exact example used in the MySQL
documentation. It doesn't matter if I execute these commands through
ODBC or directly on the console, I get this error. I've tried different
variations of the cast command with different variable types, I've also
tried the convert command, and I always get the same message. I've also
tried it on a MySQL database on Linux with the same result (I don't have
the versions, sorry).
Has anyone seen this before?
Thanks in advance...
Chris.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
