Week of month
select to_char(sysdate,'W') returns 4 although sysdate is Monday Jan 28, 2013 and in the fifth week of January 2013.Is there a glitch in SQL Plus or it calculates the week of month by simply dividing the date by 4?
How do I get SQL Plus to return the correct week of month?
How do I get SQL Plus to return the correct week of month?
0