Re: day of week

On Wed, 7 Jun 2000, Peter Eisentraut wrote:

> Karel Zak writes:
> 
> > The Oracle always directly set first week on Jan-01, but day-of-week count
> > correct... It is pretty dirty, but it is a probably set in libc's mktime().
> 
> The first week of the year is most certainly not (always) the week with
> Jan-01 in it. My understanding is that it's the first week where the
> Thursday is in the new year, but I might be mistaken. Here in Sweden much
> of the calendaring is done based on the week of the year concept, so I'm
> pretty sure that there's some sort of standard on this. And sure enough,
> this year started on a Saturday, but according to the calendars that hang
> around here the first week of the year started on the 3rd of January.
You probably right. I belive that Thomas say more about it...

> > 
> > oracle's to_char:     
> >     * week-start is a sunday 
> >     * first week start on Jan-01, but day-of-week is count continual
> > 
> > PG date_part/trunc:     
> >     * week-start in monday
> >     * first week is a first full week in new year (really?)  
> 
> The worst thing we could do is having an inconsistency here. Having a
> configuration option or two that applies to both sounds better.
Yes, but Oracle "porters" need probably oracle pseudo 
calculation..
For PG date_part/trunc will SET (or anything like this) good.
                        Karel