Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: TRUNC

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>


> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US