Re: [HACKERS] Postgresql likes Tuesday...

2002-10-01 Thread Karel Zak
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

Re: [HACKERS] Postgresql likes Tuesday...

2002-10-01 Thread Karel Zak
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)

Re: [HACKERS] Postgresql likes Tuesday...

2002-10-01 Thread Tom Lane
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

Re: [HACKERS] Postgresql likes Tuesday...

2002-10-01 Thread Tim Knowles
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

[HACKERS] Postgresql likes Tuesday...

2002-09-30 Thread Rod Taylor
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

Re: [HACKERS] Postgresql likes Tuesday...

2002-09-30 Thread Tom Lane
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

Re: [HACKERS] Postgresql likes Tuesday...

2002-09-30 Thread Hannu Krosing
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

Re: [HACKERS] Postgresql likes Tuesday...

2002-09-30 Thread Tom Lane
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

Re: [HACKERS] Postgresql likes Tuesday...

2002-09-30 Thread Hannu Krosing
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

Re: [HACKERS] Postgresql likes Tuesday...

2002-09-30 Thread Clark C. Evans
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