MS SQL Server ODBC - ODBC GETDATE Error

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

ODBC GETDATE Error

Loren Wood

2006-10-28, 7:15 pm

I am using the following syntax to get today's minus one day in order to pull
detail for yesterday. SN_EVT_DT = the date column. The O213IAVALLSCN table
is an ODBC Source and the error I am getting is:

ADO error:[Microsoft][ODBC driver for Oracle][Oracle]ORA-00904: "GETDATE":
invalid identifier

Any help would be gladly appreciated!!!!!!!!

SELECT O213IAVALLSCN.*
FROM O213IAVALLSCN
WHERE (SN_EVT_DT = TO_DATE(getdate()-1, 'MM/DD/YYYY'))

Sponsored Links