Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Help grouping results by week
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