Search results for query: *

Finally able to get a different error, don;t know if i am making progress or not :) SELECT * FROM TABLE WHERE call_date=date '2007-Aug-20' returns invalid date literal

That didn;t work either, but i appreciate all the help :) That is the funny thing, if i do SELECT * FROM TABLE SAMPLE 10 all i get in return is "invalid date",if i select specific fields from the table, but do not select the date field, i still get "invalid date". Crazy, all i can think of...

A character string failed conversion to a numeric value" Getting the same error...

Thank you bibulous! I tried that and now I am getting a different error... SELECT * FROM TABLE WHERE CALL_DATE (DATE) = '2007-08-22' "A character string failed conversion to a numeric value" Any other suggestions or even websites to hunt around? I had browsed onine and found multiple...

I am trying to build a recordset off of a teradata table using ADO. I am having a problem determining the proper syntax for the date field. I have used numerous SQL statements and they all return "Invalid Date". Here are some of the sample select statements i have tried... SELECT * FROM...