Skip to Content
0
Former Member
May 12, 2010 at 03:48 AM

Retrieve yesterday date data

246 Views

Hi all,

Please let me know how to retrieve yesterday date data. I have a field called CPUDATE. Now I wanna retrieve data until yesterday. How should I do? I just know how to retrieve data until today date

SELECT * FROM "PRD"."GMH" WHERE ( "CPUDATE" <= date(now()))

I tried to put now()-1 but it doesn't work.

Please help..

Thanks

Selvy