Home » SQL & PL/SQL » SQL & PL/SQL » date
date [message #38288] Mon, 08 April 2002 07:17 Go to next message
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 Go to previous message
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
Previous Topic: pbs with count function
Next Topic: Dynamic resultset
Goto Forum:
  


Current Time: Tue Mar 19 03:23:01 CDT 2024