I am using BETWEEN TRUNC(SYSDATE-1) and TRUNC(SYSDATE)to get all of yesterday's records in the database. THis worked last week, now I am getting an error message: FUNCTION TRUNC does not exist. Please help.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.