Skip to Content
0
Former Member
Feb 07, 2012 at 04:49 AM

SQL syntax error

21 Views

Hello Experts,

I am trying to use the SQL query

 INSERT INTO Z_DATE_FORMAT VALUES (1, TO_DATE("20120602","YYYYMMDD")) 

in a portal application. When I run the application I am getting the SQL syntax error: the token "(" was not expected here . The ''('' refers to the one next to the TO_DATE.

Any clews why I am getting the syntax error??

Thanks,

Jack