Home
Browse Code Add-Ins Blog Language Feeds Service Stats FAQs Feedback About
Manage Your Code
Snippet: Current Week of the Month (SQL)
Title: Current Week of the Month Language: SQL
Description: returns Current Week of the Month. Views: 309
Author: Maulik Soni Date Added: 7/21/2008
Copy Code   
(instr(weeks,to_char(((sysdate - next_day(trunc(sysdate, 'MM') - 7, 'Sunday'))/7),0) + 1)>0 or WEEKS is null)
Usage 
returns Current Week of the Month.
Notes
returns Current Week of the Month.