If it's of any use the following link gives some info on different schemes
and details on an ISO week numbering standard.
http://www.merlyn.demon.co.uk/weekinfo.htm#WkNo
Best Regards,
Tim Knowles
---(end of broadcast)---
TIP 1: subscribe and uns
Karel Zak <[EMAIL PROTECTED]> writes:
> What think about it our Toms?
> ...
> In the Oracle it's same (means WW vs. IW vs. D)
If it works the same as Oracle then I'm happy with it; that's what it's
supposed to do.
The real point here seems to be that EXTRACT(week) corresponds to
to_date's IW
On Mon, Sep 30, 2002 at 05:37:47PM -0400, Rod Taylor wrote:
> select to_char(
>to_date(
> CAST(extract(week from CURRENT_TIMESTAMP) as text)
> || CAST(extract(year from CURRENT_TIMESTAMP) as text)
> , 'WW')
>, 'FMDay, D');
>
> to_char
>
> Tuesday, 3
>
On Mon, Sep 30, 2002 at 06:31:15PM -0400, Tom Lane wrote:
> The middle part of that boils down (as of today) to
>
> regression=# select to_date('402002', 'WW');
> to_date
>
> 2002-10-01
> (1 row)
>
> and Oct 1 (tomorrow) is Tuesday. As to why it picks that day to
> represent
On Mon, Sep 30, 2002 at 06:49:34PM -0400, Tom Lane wrote:
| The other issue is what
| to_date(...,'WW') should do to produce a date representing a week
| number. Shouldn't it always produce the first date of that week?
| If not, what other conventions make sense?
IMHO, it should choose the "
On Tue, 2002-10-01 at 03:49, Tom Lane wrote:
> Hannu Krosing <[EMAIL PROTECTED]> writes:
> > On Tue, 2002-10-01 at 03:31, Tom Lane wrote:
> >> I notice that 2001-12-31 is considered part of the first week of 2002,
> >> which is also pretty surprising:
>
> > There are at least 3 different ways to
Hannu Krosing <[EMAIL PROTECTED]> writes:
> On Tue, 2002-10-01 at 03:31, Tom Lane wrote:
>> I notice that 2001-12-31 is considered part of the first week of 2002,
>> which is also pretty surprising:
> There are at least 3 different ways to start week numbering:
> ...
> I suspect it depends on loc
On Tue, 2002-10-01 at 03:31, Tom Lane wrote:
> Offhand this seems kinda inconsistent to me --- I'd expect
>
> regression=# select extract(week from date '2002-09-30');
> date_part
> ---
> 40
> (1 row)
>
> to produce 39, not 40, on the grounds that the first day of Week 40
> is
Rod Taylor <[EMAIL PROTECTED]> writes:
> select to_char(
>to_date(
> CAST(extract(week from CURRENT_TIMESTAMP) as text)
> || CAST(extract(year from CURRENT_TIMESTAMP) as text)
> , 'WW')
>, 'FMDay, D');
> to_char
>
> Tuesday, 3
> (1 row)
> Not that it
select to_char(
to_date(
CAST(extract(week from CURRENT_TIMESTAMP) as text)
|| CAST(extract(year from CURRENT_TIMESTAMP) as text)
, 'WW')
, 'FMDay, D');
to_char
Tuesday, 3
(1 row)
Not that it matters for me at the moment (I care that it's in the week
10 matches
Mail list logo