Home » SQL & PL/SQL » SQL & PL/SQL » ORA-1840
ORA-1840 [message #394315] Thu, 26 March 2009 07:59 Go to next message
CRISAX
Messages: 1
Registered: March 2008
Junior Member
Hello,I have a select with case when which will have to return a date, but the format is a number. Then I use that field for data calculation. what can I do to define it as data type field?
Re: ORA-01840: [message #394321 is a reply to message #394315] Thu, 26 March 2009 08:07 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Can you show us some code?

I'd guess that you want the TO_DATE function.
Re: ORA-01840: [message #394329 is a reply to message #394315] Thu, 26 March 2009 08:22 Go to previous message
deb.b
Messages: 44
Registered: December 2008
Member
Use TO_DATE function (as per your requirement)
Thanks
Previous Topic: Insert Record in extenal table?
Next Topic: How to convert Varchar2 to CLOB (split from hijacked thread)
Goto Forum:
  


Current Time: Fri Dec 02 14:16:50 CST 2016

Total time taken to generate the page: 0.14546 seconds