Re: Retrieve date of a specific day in a prior week
From: <sybrandb_at_yahoo.com>
Date: 2 Mar 2006 03:59:16 -0800
Message-ID: <1141300756.732794.228150_at_j33g2000cwa.googlegroups.com>
Date: 2 Mar 2006 03:59:16 -0800
Message-ID: <1141300756.732794.228150_at_j33g2000cwa.googlegroups.com>
What did you try to resolve this yourself? Within one minute I came up with
select next_day(trunc(sysdate,'IW')-7,'TUE') from dual
And that's all there is to it.
-- Sybrand Bakker Senior Oracle DBAReceived on Thu Mar 02 2006 - 12:59:16 CET