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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Help grouping results by week

Re: Help grouping results by week

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 8 Apr 1999 21:00:09 +0100
Message-ID: <923601702.6690.0.nnrp-03.9e984b29@news.demon.co.uk>


The trunc() function works with dates:

    trunc(sysdate,'W')
gives you the date as at the first day of the week

    trunc(sysdate,'IW')

gives you the date as at the first day of the ISO week (and there is some difference, but I can't remember why).

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk Received on Thu Apr 08 1999 - 15:00:09 CDT

Original text of this message

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