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

from rdb$database


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.