Re: AW: Re: Week number

>>>>> "AZ" == Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> writes:

>> Unix day-of-week starts on Sunday, not Monday, which is what
>> date_trunc('dow',...) returns. Presumably this is modeled on
>> the traditional notion (at least in the US; I suspect this is
>> true in most European countries at least) of Sunday being "the
>> first day of week".

AZ> Germany and Austria have Monday as first day of week, I think
AZ> most of Europe also.

I believe the goal was to have a to_char() that was complete and
Oracle-compatible. Perhaps we need to also have a trunc() which is
Oracle compatible. I haven't been playing with 7.1beta, but 7.0
trunc() doesn't like timestamps. In Oracle, I can say

select trunc(sysdate) - trunc(sysdate,'ww') + 1 from dual;

to get Monday=1.

roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD RL Enterprises
roland(at)rlenter(dot)com 76-15 113th Street, Apt 3B
rbroberts(at)acm(dot)org Forest Hills, NY 11375