| Subject | Re: [firebird-support] extract(week from d) |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-11-30T10:53:33Z |
At 06:51 PM 30/11/2006, you wrote:
people to agree on when "week 1" should start. Just looking at my
(Australia/New Zealand) diary for 2006, for example, I see that
January 1 2006 was the last day in Week 52 of 2005...and that Week 1
started on January 2. I suspect this is because the publishers of
the diary (Collins) have their own idea that Week 1 should start on
the first Monday of the year. My Collins diary for 2007 has Jan 1 in
Week 1. But - oh - my Collins diary for 2005 has Jan 1 AND Jan 2 in Week 53.
of most years. :-)
./heLen
>Hi,No. Whenever it comes up for discussion, you can't get any two
>I would like ask if there is any way in Firebird extract week number
>from
>date (so number between 1 and 52(53?)) ?
>Syntax like
> extract(week from d)
>If there is now no such feature, is it planned ?
people to agree on when "week 1" should start. Just looking at my
(Australia/New Zealand) diary for 2006, for example, I see that
January 1 2006 was the last day in Week 52 of 2005...and that Week 1
started on January 2. I suspect this is because the publishers of
the diary (Collins) have their own idea that Week 1 should start on
the first Monday of the year. My Collins diary for 2007 has Jan 1 in
Week 1. But - oh - my Collins diary for 2005 has Jan 1 AND Jan 2 in Week 53.
>Should I post this as feature request to firebird tracker ?It's sure to be there already. It seems to turn up at about Week 48
of most years. :-)
./heLen