Skip navigation
Dileep_NR
Dileep_NR
Currently Being Moderated

Oracle TO_CHAR : date changed to another after formatting.

May 22, 2012 6:01 AM

Tags: #oracle

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

691 Views   1 Reply   Latest reply: Dan Bracuk, May 22, 2012 2:11 PM
 
Replies
  • Dan Bracuk
    Currently Being Moderated
    1. Dan Bracuk,
    May 22, 2012 2:11 PM   in reply to Dileep_NR
    Report

    If you do

     

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

    from etc

     

    and then dump the results,

     

    are they the same date and time

     
    |
    Mark as:
Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Answers + Points = Status

  • 10 points awarded for Correct Answers
  • 5 points awarded for Helpful Answers
  • 10,000+ points
  • 1,001-10,000 points
  • 501-1,000 points
  • 5-500 points