Get Week Number according to ISO Standard
ISO Standard :
select to_char( date '2012-09-02', 'IW' ) from dual
look a different with
select to_char( date '2012-09-02', 'WW' ) from dual
Reference :
http://ss64.com/ora/syntax-fmt.html
ISO Standard :
select to_char( date '2012-09-02', 'IW' ) from dual
look a different with
select to_char( date '2012-09-02', 'WW' ) from dual
Reference :
http://ss64.com/ora/syntax-fmt.html