to_date do not work
francy77Jul 12 2011 — edited Jul 13 2011Hi all,
i cannot figure out why happen a things like this one:
I run
select to_date(dt_creazione_evento,'DD-MM-yyyy HH24.MI') from eventi_pm
and the output is:
02/07/0010
while should be
02/07/2010
where has gone the 2??
If i use RR instead of YYYY, it works fine also i use YY, but if i put 4 Y it lost the 2.
thanks
Francesco