first day of any given week
From: Peter Leijsten <email_leijsten_at_xs4all.nl>
Date: Wed, 4 Apr 2001 11:17:41 +0200
Message-ID: <9aeojo$75g13_at_sunsv007>
Date: Wed, 4 Apr 2001 11:17:41 +0200
Message-ID: <9aeojo$75g13_at_sunsv007>
Hi all,
I know that following query will retrieve the first day of the current week:
select (trunc(sysdate,'w')+1) from dual;
However, what I'm looking for s a query that will retrieve the first day of
any given week (input = week number of the year).
As far as I know you cannot use weeks as format code for a date
specification.
Any suggestions?
thanks in advance,
Peter Leijsten