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 Week 40
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
(1 row)
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
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
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
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 matters for
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 tomorrow
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 locale which
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 start week
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
10 matches
Mail list logo