Rajesh Somisetti

Tuesday, 3 February 2015

Week of the Year and Week of the month ?

select to_char(sysdate,'WW') FROM DUAL --- To get the week of the year


select to_char(sysdate,'W') FROM DUAL   --- nto Get the week of the month
Posted by Rajesh Somisetti at 03:12
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

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

About Me

Rajesh Somisetti
View my complete profile

Blog Archive

  • ►  2017 (2)
    • ►  September (1)
    • ►  July (1)
  • ►  2016 (8)
    • ►  September (1)
    • ►  May (1)
    • ►  February (2)
    • ►  January (4)
  • ▼  2015 (18)
    • ►  October (1)
    • ►  September (4)
    • ►  July (2)
    • ►  June (2)
    • ►  May (1)
    • ►  April (1)
    • ▼  February (3)
      • Assigning a value to a temporary variable (like At...
      • Convert the time zone Based on the Organization
      • Week of the Year and Week of the month ?
    • ►  January (4)
  • ►  2014 (21)
    • ►  December (3)
    • ►  November (2)
    • ►  October (4)
    • ►  September (1)
    • ►  August (3)
    • ►  July (3)
    • ►  June (1)
    • ►  March (2)
    • ►  February (2)
Simple theme. Powered by Blogger.