Using NOW() - hours/days in query

[ravensensei]

I'm trying to write a query that allows me to look at data from the day before. It's a job I'm running at 3am, and I'd like to get all the data from the day before from 12:01am until 11:59 pm.

I looked around for documentation, but I can't find any on offsetting NOW().

 

[jongpau]

Have a look at the "datetime" and "datetime-tz" functions in the online help. These allow you to create datetime value you can use in your query


HTH

Paul

 

[ravensensei]

It does, where can I find the online help tho?

Have a look at the "datetime" and "datetime-tz" functions in the online help. These allow you to create datetime value you can use in your query


HTH

Paul

 

[ravensensei]

Have a look at the "datetime" and "datetime-tz" functions in the online help. These allow you to create datetime value you can use in your query


HTH

Paul

Ack! Didn't realize I could use SYSDATE - 1 to get yesterday.