Windows 3002 Web Edition, R:Tango 5, Oterro update 3
Can't figure out what is wrong with the following DBMS action:
SELECT B2.B_ID, B2.B_ShopperID, P1.P_Name, B2.B_Quantity, P1.P_Price1,
B2.B_TimeStamp FROM Products P1, Basket B2 WHERE ((P1.P_ID=B2.P_ID) AND (
(b2.B_TimeStamp >= '2004/01/01 00:00:01') and ('2004/12/01 23:23:59' <=
b2.B_TimeStamp) ))
2418 [RBTI][Oterro ODBC Driver][Catalog]-ERROR- Invalid DATETIME value
(2418) S1000
I have tried 2004/12/01, 12/01/2004, 12/01/2004 23:23:59. Nothing seems to
work.
b2.B_TimeStamp is a field with the Timestamp Datatype.
Any ideas?
Steve Fogelson
Internet Commerce Solutions
