View Single Post
10-29-2012, 09:42 PM
Join Date: Sep 2002
Location: Saskatoon, Saskatchewan
Thanked 2,598 Times in 2,567 Posts
DATEADD isn't a part of ORACLE SQL.
What will work is
ADATEFIELD - INTERVAL '1' DAY(1)
. Although you'll still need to compare it to something.
That error itself looks to me like a SQL Server error, not a Oracle error.
View Public Profile
Find More Posts by Fou-Lu