date [message #38288] |
Mon, 08 April 2002 07:17 |
Sam
Messages: 255 Registered: April 2000
|
Senior Member |
|
|
does any one know how to get the current week from sysdate.
i mean something like this...
04/07/2002 - 04/13/02
appreciate any help.
|
|
|
Re: date [message #38291 is a reply to message #38288] |
Mon, 08 April 2002 07:51 |
Jon
Messages: 483 Registered: May 2001
|
Senior Member |
|
|
11:46:36 ==> select next_day(sysdate-7,'SUNDAY'), next_day(sysdate,'SATURDAY') from dual;
NEXT_DAY(S NEXT_DAY(S
---------- ----------
04/07/2002 04/13/2002
|
|
|