RE: CAST fails

* 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 erro

CAST fails

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 '('20