SQL*Plus (MOSC)

MOSC Banner

Week of month

edited Feb 1, 2013 8:25PM in SQL*Plus (MOSC) 4 commentsAnswered
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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center