Doubt

[gnagesh]

Hi

What is returned value "3" here.

select to_char(sysdate,'DDD'),to_char(sysdate,'DD'),
to_char(sysdate,'D')
from dual;

TO_ TO T
--- -- -
218 06 3

Thanks In Advance

[sandycrab]

what is your actual sysdate?

[gnagesh]

Originally posted by sandycrab
what is your actual sysdate?

SQL> select sysdate from dual;

SYSDATE
---------
06-AUG-02

Thanks In Advance

[jmodic]

Originally posted by gnagesh
Hi

What is returned value "3" here.

select to_char(sysdate,'DDD'),to_char(sysdate,'DD'),
to_char(sysdate,'D')
from dual;

TO_ TO T
--- -- -
218 06 3

Thanks In Advance

"3" as an output of TO_CHAR(sysdate,'D') represent the day number of the week, ranging from 1 to 7. With your NLS settings the above expression returns

1 .. Sunday
2 .. Monday
3 .. Tuesday
.......
7 .. Satturday

This numbering is NLS_TERRITORY dependant, in some cases you get 1 for Monday and 7 for Sunday.

[gnagesh]

Hi all

Thank You Very Much.

Regards