>>>>> "AZ" == Zeugswetter Andreas SB <ZeugswetterA@wien.spardat.at> writes:
>> Unix day-of-week starts on Sunday, not Monday, which is what >> date_trunc('dow',...) returns. Presumably this
ismodeled 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@rlenter.com 76-15 113th Street, Apt 3B
rbroberts@acm.org Forest Hills, NY 11375