Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Teradata and Date Formats for ADO
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- fer2485
- Post #9
- Forum: NCR: Teradata
-
Teradata and Date Formats for ADO
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...- fer2485
- Post #8
- Forum: NCR: Teradata
-
Teradata and Date Formats for ADO
A character string failed conversion to a numeric value" Getting the same error...- fer2485
- Post #5
- Forum: NCR: Teradata
-
Teradata and Date Formats for ADO
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...- fer2485
- Post #3
- Forum: NCR: Teradata
-
Teradata and Date Formats for ADO
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...- fer2485
- Thread
- Replies: 8
- Forum: NCR: Teradata
