OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » SQL question

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQL question [message #11245]

Mon, 15 March 2004 17:35

Sarfraz
Messages: 1
Registered: March 2004

Junior Member

�

How�to��convert the number to date format in SQL select statement. The oracle datebase field stores the date as number (like 1079401176211)

Thanks and Regards

�

Report message to a moderator

Re: SQL question [message #11257 is a reply to message #11245]

Tue, 16 March 2004 04:43

Art Metzer
Messages: 2480
Registered: December 2002

Senior Member

SQL> ALTER SESSION SET NLS_DATE_FORMAT = 'fmDy MM/DD/YYYY HH:fmMI:SS AM'
  2  /
 
Session altered.
 
SQL> SELECT TO_DATE('197001','YYYYMM') + (<font color=red><b>1079401176211</b></font>/24/60/60/1000) d
  2  FROM   DUAL
  3  /
 
D
--------------------------
Tue 3/16/2004 1:39:36 AM
 
SQL>

Report message to a moderator

Previous Topic:	What is advantage of using PLS_INTEGER?
Next Topic:	XMLtype?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 03:05:52 CDT 2024