Oracle TO_CHAR : date changed to another after formatting.

Date stored in Oracle DB- 2012-05-16 14:12:45. -=9:A2 (please note the date is 15)

In Oracle SQL Query I have used the following format

TO_CHAR(<<column name>>,'Month dd, YYYY HH12:MI:SS AM TZD')

Reslt- May 22, 2012 08:04:45 AM EDT(please note the daet is 22)

how date become 22 from 15?

Also how the inserted in with  -=9.A2

Thanks

Este tema ha sido cerrado para respuestas.

Inspiring

If you do

select yourcolumn, to_char(yourcolumn, 'mask') x

from etc

and then dump the results,

are they the same date and time

Regístrese