Home » SQL & PL/SQL » SQL & PL/SQL » Date conversation issue (oracle,9.2.0.8,window)
Date conversation issue [message #342822] Mon, 25 August 2008 04:22 Go to next message
vickey_sagar1
Messages: 77
Registered: August 2007
Location: pune
Member

Hi All,

I am trying to convert number column in date format but I am getting error could you please suggest me what changes require in this query

Select ARRIVAL_TIME from helpdesk  where CASE_ID_='HD8002634';

ARRIVAL_TIME
------------
  1209357082

select  to_char(to_date(ARRIVAL_TIME, 'J'), 'mm/dd/yyyy')  from hpd_helpdesk  where CASE_ID_='HD8002634'
                        *
ERROR at line 1:
ORA-01830: date format picture ends before converting entire input string.


Thanks,
Sagar


Re: Date conversation issue [message #342829 is a reply to message #342822] Mon, 25 August 2008 04:31 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
since that Julian date would be "1209357082 days since December 31, 4713 BC", that would be the year 3308594.

Since I don't think you are programming this for the TARDIS, maybe you should divide the number by something before using it as a Julian date.
Previous Topic: what is BYPASS_UJVC? in update statement
Next Topic: INVALID IDENTIFIER IN JOINING SCRIPT
Goto Forum:
  


Current Time: Wed Dec 07 06:34:23 CST 2016

Total time taken to generate the page: 0.33230 seconds