* Christopher Bell
> 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
CAST() is a brand new function in mysql, according to <URL:
http://www.mysql.com/doc/C/a/Cast_Functions.html > it was added in MySQL
4.0.2.
--
Roger
---------------------------------------------------------------------
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
