rgn2121
asked on
Difference between Oracle's date formatted as "ww" and Access' formatted as "ww"?
I have a query in which I convert a date to it's week of the year "ww". When I am writting the code to run directly on the Oracle Tables I use:
To_Char(To_Date("Some_Date ",'MM/DD/Y YYY'),'WW' ) as WkOfYear
In Access I am doing this:
Format(qryTemp_Data!Some_D ate,"ww") AS WkOfYear
What I have found is that for the 4th of February, Oracle says it is the 5th week, but Access says it is the 6th. I know that the 5th of February would actually be the true 6th week, and Oracle changes to the 6th week on that day, but I am curious what each looks at and is there a way to make it so that the full "Work Week" is the same in Oracle and not split up?
To_Char(To_Date("Some_Date
In Access I am doing this:
Format(qryTemp_Data!Some_D
What I have found is that for the 4th of February, Oracle says it is the 5th week, but Access says it is the 6th. I know that the 5th of February would actually be the true 6th week, and Oracle changes to the 6th week on that day, but I am curious what each looks at and is there a way to make it so that the full "Work Week" is the same in Oracle and not split up?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Okay...it was an " i " and not an " L "...That was the issue... Thanks
ASKER
I gave most of the points to sujith80 since he had the right solution, I just couldn't tell if it was an " i " or an " L ". Thanks to both!
ASKER
To_Char(To_Date("Some_Date
Some date is one of the fields of an inner query....