Vincente Aggrippino wrote:
The following query runs fine on my test server at home, running MySQL
5.0.15, but on my hosting provider's server, running MySQL 4.0.24, it
gets a syntax error. Can anyone help me figure out why? ...
insert into product (name, url, cost, purchase_dt)
values('Whatchamacallit', 'http://www.whatchamacallit.com', 50000,
str_to_date('2006-04-20', '%Y-%m-%d'))
Here's the error message :
#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 '('2006-04-20', '%Y-%m-%d'))' at line 2
Thank you,
Vince Aggrippino
He doesn't know str_to_date. That's it.
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]