| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Week Date Format
O Wise Colleagues,
The date format 'W', as in to_char (sysdate, 'W') returns the week of the month, counting the first seven days of the month as week 1 and so on. Week 1 always has seven days, week 5 either has 1, 2, or 3 days, or doesn't exist.
I'd like to have my weeks starting on Sunday going through Saturday, so that week 1 may only have 1 day in it (if the first of the month is Saturday), and week two starts on the second day of the month. The ISO date format works for week of the year, but not for week of the month.
I suppose I could write a function subtracting the iso week of year of the first of the month from the current iso week of year or something like that. Has anyone been there done this?
anksthay uchmay,
Yosi
 |
 |