Forum Discussion

vlad230's avatar
vlad230
Contributor
14 years ago

[TC8 + JScript + ADO] SQL statement not returning the proper values

Hi all, I'm trying to do some SQL selects on a Oracle Database and I'm not getting the proper results. The odd thing is that if I do a query within Oracle SQL Developer I get 2 results a...
vlad230's avatar
vlad230
Contributor
14 years ago
I managed to solve this issue after all.



The problem was with the query indeed, although it's still strange because it worked in SQL developer.



The year needs to be defined with 4 digits like so:





var query = "SELECT promoname FROM database.promotion WHERE promoenddate = '2008-09-01'";





Thanks.