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