Dear List, It's been a long, long time since I've used mysql and I happen to need to work with dates. Amongst my many, demanding requirements is the ability to enter a literal date. My attempts thus far have been less than encouraging:
mysql> select cast('2004-01-01' as date); ERROR 1064: You have an error in your SQL syntax near '('2004-01-01' as date)' at line 1 mysql> select convert('2004-01-01' as date); ERROR 1064: You have an error in your SQL syntax near '('2004-01-01' as date)' at line 1 mysql> select convert('2004-01-01',date); ERROR 1064: You have an error in your SQL syntax near '('2004-01-01',date)' at line 1 mysql> select cast('2004-01-01',date); ERROR 1064: You have an error in your SQL syntax near '('2004-01-01',date)' at line 1 mysql> And this is the version it claims to be: $ mysql --version mysql Ver 11.18 Distrib 3.23.58, for pc-linux-gnu (i686) I've looked at http://dev.mysql.com/doc/mysql/en/Cast_Functions.html and a bunch of other pages @ mysql.com. None of the examples seem to work on mysql 3 (It seems that the mysql.com docs refer to mysql 4). Any ideas? Thanks all, James. -- James Gregory <[EMAIL PROTECTED]>
signature.asc
Description: This is a digitally signed message part
-- SLUG - Sydney Linux User's Group Mailing List - http://slug.org.au/ Subscription info and FAQs: http://slug.org.au/faq/mailinglists.html