Date field does not get updated correctly
UPDATE table1 SET field1=TO_DATE('13-OCT-13','DD-MON-YY') WHERE field2='TEST'
It seems to have update the date but day of the week still shows up as Monday instead of Sunday.
When I run
SELECT TO_CHAR(TO_DATE( FIELD1, 'DD-MON-YY'),'DY') FROM TABLE1 WHERE FIELD2='TEST'
I get
'MON' returned, even though the date is '13-OCT-13', which is a Sunday.
How can I fix that?