|Subject||RE: [firebird-support] Extract week of the year (within year)|
|Author||Svein Erling Tysvær|
>is possible to get week of the year "within year"?
>I see that built in functions only support ISO-8601 (or i do not know some parameter)
Actually, Karol, “week within year” is not the week, Karol. 1 January could be week 53 and 31 December could be week 1. If you want to consider 1 January always as part of week 1 (even if that day could be the only day of week 1), I’d suggest you try something like:
select (extract(yearday from cast('1.1.2014' as date))-extract(weekday from cast('1.1.2014' as date)))/7+1
If you want the first seven days of a week to always be week 1 (and changing which day a week start with for each year), you could drop the second EXTRACT.