Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Inconsistency while retrieving rows in sequel query.(To_Char)
When I use YY as fromat model in TO_CHAR function, I get Sunday as the Day of
my birthday.
And when I use YYYY as fromat Model I get Monday.
Why is this inconsistency in Oracle? or Am I doing something wrong???
I use Oracle 8.1.6.
SQL> SELECT TO_CHAR(TO_DATE('01-20-75','MM-DD-YY'),'Day') "My Birthday" FROM dual;
My Birthd
SQL> SELECT TO_CHAR(TO_DATE('01-20-1975','MM-DD-YYYY'),'Day') "My Birthday" FROM dual;
My Birthd
![]() |
![]() |