skip to main | skip to sidebar

ORACLE APPS

ORACLE APPS TECHNICAL CONCEPTS

Thursday, May 5, 2016

SQL to fetch first day and last day of the month

SELECT LEVEL,
       TO_CHAR (TRUNC (ADD_MONTHS (SYSDATE, LEVEL - 1), 'MM'), 'DD-MON-RRRR'),
       TO_CHAR (LAST_DAY (ADD_MONTHS (SYSDATE, LEVEL - 1)), 'DD-MON-RRRR')
FROM DUAL
CONNECT BY LEVEL <= 100;
Posted by Rajesh Chigullapalli at 3:11 AM

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2019 (1)
    • ►  September (1)
  • ►  2017 (3)
    • ►  March (1)
    • ►  February (1)
    • ►  January (1)
  • ▼  2016 (5)
    • ▼  May (3)
      • SQL to fetch first day and last day of the month
      • How to open wrapped Package Source Code in Oracle ...
      • How to fetch current login user using sql
    • ►  March (2)
  • ►  2014 (12)
    • ►  December (1)
    • ►  November (1)
    • ►  July (1)
    • ►  June (1)
    • ►  May (1)
    • ►  April (4)
    • ►  February (1)
    • ►  January (2)
  • ►  2013 (20)
    • ►  December (3)
    • ►  November (1)
    • ►  September (3)
    • ►  August (2)
    • ►  July (8)
    • ►  June (1)
    • ►  March (2)
  • ►  2012 (36)
    • ►  November (2)
    • ►  October (9)
    • ►  September (2)
    • ►  August (2)
    • ►  July (4)
    • ►  June (6)
    • ►  May (6)
    • ►  April (4)
    • ►  March (1)
  • ►  2011 (3)
    • ►  February (3)
  • ►  2010 (14)
    • ►  September (1)
    • ►  July (2)
    • ►  June (1)
    • ►  May (6)
    • ►  April (3)
    • ►  March (1)
  • ►  2009 (2)
    • ►  May (1)
    • ►  April (1)
  • ►  2008 (4)
    • ►  May (2)
    • ►  April (2)

About Me

Rajesh Chigullapalli
View my complete profile