Home » SQL & PL/SQL » SQL & PL/SQL » last day of first week in a month
last day of first week in a month [message #287501] Wed, 12 December 2007 07:14 Go to next message
world.apps
Messages: 70
Registered: January 2007
Location: Hyderabad
Member
Hi,

Could you help me in finding the last day of first week in a month?

Thanks in advance
Re: last day of first week in a month [message #287503 is a reply to message #287501] Wed, 12 December 2007 07:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Depending on the original problem there is several possible answer.
Have a look at NEXT_DAY and TRUNC functions, for instance.

Regards
Michel
Re: last day of first week in a month [message #287542 is a reply to message #287501] Wed, 12 December 2007 10:25 Go to previous messageGo to next message
amit.navapara
Messages: 5
Registered: December 2007
Location: Bangalore
Junior Member


Try This...

TO_CHAR(TRUNC(SYSDATE,'MONTH') + 6,'DAY')


in your logic.
Re: last day of first week in a month [message #287546 is a reply to message #287542] Wed, 12 December 2007 10:38 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Depends on what week means.
Is first week start with:
- first day of month
- standard (for your territory) first day of the first complete week in the month
- standard first day of the first week that contains at least 4 days in the month

Regards
Michel
Re: last day of first week in a month [message #287631 is a reply to message #287501] Thu, 13 December 2007 00:25 Go to previous messageGo to next message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

Are you looking for this?

SQL> SELECT NEXT_DAY (TO_DATE ('01092007', 'ddmmyyyy') - 1, 'SAT')||' - '||
  2         TO_CHAR (NEXT_DAY (TO_DATE ('01092007', 'ddmmyyyy') - 1, 'SAT'), 'DAY') SEPTEMBER,
  3         NEXT_DAY (TO_DATE ('01102007', 'ddmmyyyy') - 1, 'SAT')||' - '||
  4         TO_CHAR (NEXT_DAY (TO_DATE ('01102007', 'ddmmyyyy') - 1, 'SAT'), 'DAY') OCTOBER,
  5         NEXT_DAY (TO_DATE ('01112007', 'ddmmyyyy') - 1, 'SAT')||' - '||
  6         TO_CHAR (NEXT_DAY (TO_DATE ('01112007', 'ddmmyyyy') - 1, 'SAT'), 'DAY') NOVEMBER,
  7         NEXT_DAY (TO_DATE ('01122007', 'ddmmyyyy') - 1, 'SAT')||' - '||
  8         TO_CHAR (NEXT_DAY (TO_DATE ('01122007', 'ddmmyyyy') - 1, 'SAT'), 'DAY') DECEMBER
  9    FROM DUAL;

SEPTEMBER             OCTOBER               NOVEMBER              DECEMBER
--------------------- --------------------- --------------------- ---------------------
01-SEP-07 - SATURDAY  06-OCT-07 - SATURDAY  03-NOV-07 - SATURDAY  01-DEC-07 - SATURDAY


Kiran.
Re: last day of first week in a month [message #287640 is a reply to message #287631] Thu, 13 December 2007 00:33 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thansk we could not find it without your help.

Regards
Michel
Re: last day of first week in a month [message #287650 is a reply to message #287501] Thu, 13 December 2007 01:05 Go to previous message
kir_ait
Messages: 198
Registered: November 2007
Location: Bangalore,India
Senior Member

Not to mention Mr.Michel. Atleast now you could find it, right? Laughing

Cheers.
Kiran
Previous Topic: What are the types of index?
Next Topic: Materialized Views
Goto Forum:
  


Current Time: Fri Dec 09 00:03:00 CST 2016

Total time taken to generate the page: 0.05647 seconds