Oracle-L: Re: TRUNC

From: Ian Skepper <gblegl7j_at_IBMMAIL.COM>
Date: Wed, 7 Feb 1996 10:56:01 EST
Message-Id: <9602071620.AA28924@alice.jcc.com>

Mail Item Text Follows
- Received from ISS.SKEPPEI 6031 07-02-96 15.53 -> MAILEX.IBMMAIL.INTERNET -: - - - - - - - - - - > ROUTING VIA MAIL EXCHANGE

> I am using TRUNC to try and get the Monday of a given week

Jim,

What you need is something like :-

SELECT TRUNC(TO_DATE('17-FEB-94'), 'D') + 1 FROM DUAL; The 'WW' you were using is the first day of the year, 'D' is the first day of the week. According to Oracle, this is Sunday, hence the +1.

Hope this helps,

Ian Skepper
Legal & General
gblegl7j_at_ibmmail.com Received on Wed Feb 07 1996 - 11:20:32 CST