AndreasAuer
IS-IT--Management
My problem is the following:
I need to convert a date into week and year. I use to_char(date,'yyyy.iw'). The problem is that, if the date is in the last days of december but is in week 1 of the next year. For example: 31-dec-2001 should be 01.2002 but it returns 01.2001.
How can a solve this problem??
I need to convert a date into week and year. I use to_char(date,'yyyy.iw'). The problem is that, if the date is in the last days of december but is in week 1 of the next year. For example: 31-dec-2001 should be 01.2002 but it returns 01.2001.
How can a solve this problem??