SYSDATE

[vehto]

Question: simple maybe ?
I would like too query data for the past 7 days using sysdate

where To_CHAR (Collect_dt 'MM/DD/YYYY' = To_CHAR(sysdate ? 'MM/DD/YYYY')

sysdate-7 returns only data for one day

Thanks
vehto

 

[SantaMufasa]

Vehto,

This should meet your needs:

SELECT whatever...
FROM whatever...
where Collect_dt between trunc(sysdate)-7 and sysdate;

This gives you all data from midnight on the morning seven days ago, up to the current minute/second.

Does this do what you want?

Dave

 

[vehto]

Excellent That did the trick !!

Thanks for your help SantaMufasa !