Home » SQL & PL/SQL » SQL & PL/SQL » Date Question
Date Question [message #188454] Fri, 18 August 2006 11:25 Go to next message
Vishal_7
Messages: 63
Registered: April 2005
Member
Hi,

I have a problem and need help with dates. Today its the 18th - now I need to get the start and end date from last week - Where start day should be saturdary and end day is sunday. How would I get that?

Thanks for any help.
Re: Date Question [message #188457 is a reply to message #188454] Fri, 18 August 2006 11:57 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Vishal_7 wrote on Fri, 18 August 2006 11:25

Where start day should be saturdary and end day is sunday.

I'm not sure I understand how you could have the start day on Saturday and the end day on Sunday.

SQL> select next_day(sysdate - 14, 'SUNDAY') "Sunday",
  2  next_day(sysdate - 7, 'SATURDAY') "Saturday" from dual;

Sunday    Saturday
--------- ---------
06-AUG-06 12-AUG-06

Re: Date Question [message #188459 is a reply to message #188457] Fri, 18 August 2006 12:06 Go to previous message
Vishal_7
Messages: 63
Registered: April 2005
Member
UUps...I meant from Sunday to Saturday (sorry about that)
Previous Topic: stored proc > cursor as output to java > max cursors exceeded > due to not closing in excep
Next Topic: How can I find any change on source code whatever packages or types???
Goto Forum:
  


Current Time: Fri Dec 09 06:16:04 CST 2016

Total time taken to generate the page: 0.20670 seconds