Date

[ridhirao22]

Hi,

Using Oracle 10 g

I used a sql to get the date format for yyyyQ
and expected to see 01-JAN-1990 but I see 01-FEB-1990

SELECT TO_DATE(SUBSTR('19903',1,4),'YYYY')FROM Dual

What could the problem be?

TIA,
RR

 

[karluk]

See my response in your other thread. To_date with a 'YYYY' format mask has some unexpected dependencies on the currect value of sysdate.

 

[ridhirao22]

Thank you very much!