Queries Using Week

[Charles Dornbos <charlied@TIR.COM>]

Hi, I am using SQR3 and Oracle 7.2 and have written a report the uses a
Oracle edit mask: to_char(changedate, 'WW'). The returns the week of the
year that change date is in. There is just one small problem. Oracle assumes
that since Jan 1, 1997 was a Wednesday, the first day of the week is a
Wednesday and the last day is a Tuesday. I need the first day of the week to
be a Monday and the last day to be a Sunday. Now I've used an Alter session
command in a SQL to change Oracle's date format for a report, is there a way
to change the day a week starts? I know this is kind of a Oracle question so
I hope I don't get flamed to death, but I'm trying to write this SQR3 report
using this function or a reasonable equivalent.
        Thanks and have a Merry Christmas
                charlied@tir.com