Previous Week

[system]

Hi,

User relative date functions as mentioned in this old topic:

Oracle Relative Date Functions

Just thought I’d help people out by posting some as a quick reference Yesterday: trunc(sydate)-1 Today: trunc(sysdate) Start of Current Month: trunc(sysdate,'mm') End of Current Month: last_day(sysdate) Start of Previous Month: trunc((trunc(sysdate,'mm')-1),'mm') End of Previous Month: trunc(sysdate,'mm')-1 Start of Current Quarter: trunc(sysdate,'q') End of Current Quarter: add_months(trunc(sysdate,'q'),3)-1 Start of Previous Quarter: trunc(trunc(sysdate,'q')-1,'q') End of Previous Qu…

---

Marek Chladny (BOB member since 2003-11-27)