Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Get back the date from a given week number

MagooOct 30 2009 — edited Oct 30 2009
Hi!

Somebody knows a nice trick for getting back a date from a given week number?

For example: i give a week number as parameter to a report with to_char ( sysdate, 'IWYYYY' );
Now, how can i get back the date from that string?
select to_date ( to_char ( sysdate, 'iwyyyy' ), 'iwyyyy' ) from dual;
throws: ORA-01820: format code cannot appear in date input format

Thanks in advance!

Regards
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 27 2009
Added on Oct 30 2009
3 comments
3,583 views