system
October 6, 2010, 7:21am
#1
hi,
i need a predefined filter for last week (last week 7 days) how to create this please provide the syntax my DB is oracle and DB field is having timestamp
Thanks in Advance
sat.dpi (BOB member since 2009-02-12)
system
October 6, 2010, 7:33am
#2
Hi,
This topic should get you started:
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)
system
October 6, 2010, 1:46pm
#3
If you are using MS SQL server use thisdateadd(dd,-7,current_timestamp)
in predefined filter
krvin (BOB member since 2010-08-16)
(BOB member since 2009-02-12)
(BOB member since 2003-11-27)