List:General Discussion« Previous MessageNext Message »
From:Vincente Aggrippino Date:April 21 2006 7:21am
Subject:mysql 5 vs. mysql 4: str_to_date
View as plain text  
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', '', 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
mysql 5 vs. mysql 4: str_to_dateVincente Aggrippino21 Apr
  • Re: mysql 5 vs. mysql 4: str_to_dateBarry21 Apr
  • Re: mysql 5 vs. mysql 4: str_to_dateDan Nelson21 Apr