 | |
return the correct WW value
comp.databases.oracle.misc comp.databases.oracle.misc
 |
| | Thread Tools | Display Modes |
#11
 
| |||
| |||
|
Re: return the correct WW value -
10-28-2008
, 09:24 PM
|
On Oct 29, 10:01*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com I have a problem for retrieving a correct ww. I hit a snag while testing the serverPerformanceWeekly script. *It seems the TO_CHAR(<date>,'WW') function is not returning the correct value. *See sample below for 26-Oct-2008 (last Sunday), 43 was returned instead of 44. How shud i do? SQL> select to_char(to_date('20081026','YYYYMMDD'),'WW') from serverPerformanceWeekly; TO -- 43 *SQL> select to_char(sysdate, 'WW') from dual; 44 On what "sysdate" did you run the above to get that result? *On the Monday after you discovered the "error" or actually on the Sunday? *Did you run the above form a client connection? *What's your (client and server) NLS_TERRITORY setting? *Does that setting default the first day of the week as a Sunday or as a Monday? I'm trying to research how to return the correct WW value (week starts on a Sunday). have you encountered this before in SQL? |
I think you're looking for 'IW' (week of year based on ISO standard)
rather than 'WW" (week of year calculated on weeks starting on the day of
the week defined by whatever January 1st was).
Geoff M
#12
| |||
| |||
|
|
On Oct 29, 10:01*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com I have a problem for retrieving a correct ww. I hit a snag while testing the serverPerformanceWeekly script. *It seems the TO_CHAR(<date>,'WW') function is not returning the correct value. *See sample below for 26-Oct-2008 (last Sunday), 43 was returned instead of 44. How shud i do? SQL> select to_char(to_date('20081026','YYYYMMDD'),'WW') from serverPerformanceWeekly; TO -- 43 *SQL> select to_char(sysdate, 'WW') from dual; 44 On what "sysdate" did you run the above to get that result? *On the Monday after you discovered the "error" or actually on the Sunday? *Did you run the above form a client connection? *What's your (client and server) NLS_TERRITORY setting? *Does that setting default the first day of the week as a Sunday or as a Monday? I'm trying to research how to return the correct WW value (week starts on a Sunday). have you encountered this before in SQL? |
I think you're looking for 'IW' (week of year based on ISO standard)
rather than 'WW" (week of year calculated on weeks starting on the day of
the week defined by whatever January 1st was).
Geoff M
#13
| |||
| |||
|
|
On Oct 29, 10:01*am, Geoff Muldoon <geoff.muld... (AT) trap (DOT) gmail.com I have a problem for retrieving a correct ww. I hit a snag while testing the serverPerformanceWeekly script. *It seems the TO_CHAR(<date>,'WW') function is not returning the correct value. *See sample below for 26-Oct-2008 (last Sunday), 43 was returned instead of 44. How shud i do? SQL> select to_char(to_date('20081026','YYYYMMDD'),'WW') from serverPerformanceWeekly; TO -- 43 *SQL> select to_char(sysdate, 'WW') from dual; 44 On what "sysdate" did you run the above to get that result? *On the Monday after you discovered the "error" or actually on the Sunday? *Did you run the above form a client connection? *What's your (client and server) NLS_TERRITORY setting? *Does that setting default the first day of the week as a Sunday or as a Monday? I'm trying to research how to return the correct WW value (week starts on a Sunday). have you encountered this before in SQL? |
I think you're looking for 'IW' (week of year based on ISO standard)
rather than 'WW" (week of year calculated on weeks starting on the day of
the week defined by whatever January 1st was).
Geoff M
#14
| |||
| |||
|
|
25c23db00... (AT) p39g2000hsb (DOT) googlegroups.com>, says... I have a problem for retrieving a correct ww. I hit a snag while testing the serverPerformanceWeekly script. It seems the TO_CHAR(<date>,'WW') function is not returning the correct value. See sample below for 26-Oct-2008 (last Sunday), 43 was returned instead of 44. How shud i do? SQL> select to_char(to_date('20081026','YYYYMMDD'),'WW') from serverPerformanceWeekly; TO -- 43 SQL> select to_char(sysdate, 'WW') from dual; 44 On what "sysdate" did you run the above to get that result? On the Monday after you discovered the "error" or actually on the Sunday? Did you run the above form a client connection? What's your (client and server) NLS_TERRITORY setting? Does that setting default the first day of the week as a Sunday or as a Monday? Geoff M |
on a Sunday). have you encountered this before in SQL?
----------------------------------------------------------
You should have a closer look at datetime format elements definition:
http://download.oracle.com/docs/cd/B...004.htm#i34948
Regards
Michel
#15
| |||
| |||
|
|
25c23db00... (AT) p39g2000hsb (DOT) googlegroups.com>, says... I have a problem for retrieving a correct ww. I hit a snag while testing the serverPerformanceWeekly script. It seems the TO_CHAR(<date>,'WW') function is not returning the correct value. See sample below for 26-Oct-2008 (last Sunday), 43 was returned instead of 44. How shud i do? SQL> select to_char(to_date('20081026','YYYYMMDD'),'WW') from serverPerformanceWeekly; TO -- 43 SQL> select to_char(sysdate, 'WW') from dual; 44 On what "sysdate" did you run the above to get that result? On the Monday after you discovered the "error" or actually on the Sunday? Did you run the above form a client connection? What's your (client and server) NLS_TERRITORY setting? Does that setting default the first day of the week as a Sunday or as a Monday? Geoff M |
on a Sunday). have you encountered this before in SQL?
----------------------------------------------------------
You should have a closer look at datetime format elements definition:
http://download.oracle.com/docs/cd/B...004.htm#i34948
Regards
Michel
#16
| |||
| |||
|
|
25c23db00... (AT) p39g2000hsb (DOT) googlegroups.com>, says... I have a problem for retrieving a correct ww. I hit a snag while testing the serverPerformanceWeekly script. It seems the TO_CHAR(<date>,'WW') function is not returning the correct value. See sample below for 26-Oct-2008 (last Sunday), 43 was returned instead of 44. How shud i do? SQL> select to_char(to_date('20081026','YYYYMMDD'),'WW') from serverPerformanceWeekly; TO -- 43 SQL> select to_char(sysdate, 'WW') from dual; 44 On what "sysdate" did you run the above to get that result? On the Monday after you discovered the "error" or actually on the Sunday? Did you run the above form a client connection? What's your (client and server) NLS_TERRITORY setting? Does that setting default the first day of the week as a Sunday or as a Monday? Geoff M |
on a Sunday). have you encountered this before in SQL?
----------------------------------------------------------
You should have a closer look at datetime format elements definition:
http://download.oracle.com/docs/cd/B...004.htm#i34948
Regards
Michel
#17
| |||
| |||
|
|
25c23db00... (AT) p39g2000hsb (DOT) googlegroups.com>, says... I have a problem for retrieving a correct ww. I hit a snag while testing the serverPerformanceWeekly script. It seems the TO_CHAR(<date>,'WW') function is not returning the correct value. See sample below for 26-Oct-2008 (last Sunday), 43 was returned instead of 44. How shud i do? SQL> select to_char(to_date('20081026','YYYYMMDD'),'WW') from serverPerformanceWeekly; TO -- 43 SQL> select to_char(sysdate, 'WW') from dual; 44 On what "sysdate" did you run the above to get that result? On the Monday after you discovered the "error" or actually on the Sunday? Did you run the above form a client connection? What's your (client and server) NLS_TERRITORY setting? Does that setting default the first day of the week as a Sunday or as a Monday? Geoff M |
on a Sunday). have you encountered this before in SQL?
----------------------------------------------------------
You should have a closer look at datetime format elements definition:
http://download.oracle.com/docs/cd/B...004.htm#i34948
Regards
Michel
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.