Thanks all,
i forgot about another locales like Sunday first day.
I see that supporting official function in FB will be problematic
then i do this in this way
SELECT
EXTRACT(YEAR FROM FLD_DATE),
CASE
WHEN EXTRACT(yearday FROM FLD_DATE)100 AND EXTRACT(WEEK FROM FLD_DATE)50
THEN 0
On Tue, 24 Mar 2015 09:23:54 +0100, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]
firebird-support@yahoogroups.com wrote:
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
=?utf-8?B?U3ZlaW4gRXJsaW5nIFR5c3bDpnI=?=
svein.erling.tysv...@kreftregisteret.no [firebird-support] skrev:
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
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