Forum Discussion

vlad230's avatar
vlad230
Contributor
13 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...
tristaanogre's avatar
tristaanogre
Esteemed Contributor
13 years ago
Actually, that makes sense.  Probably SQL developer knows a bit more how to indicate which format the string is in to know what is the year part... you're using ADO which is much more low level.  Technically, if the field is an actual DateTime field, it's not actually stored as a string but as a numeric value so it needs to convert that string to a numeric.



Anyways, glad you found a solution.