SQL - Number To Date

[pandiarajan]

Hi,

My database is Oracle 10g. DATE is stored NUMBER datatype on a table and I need to access this number and display it in Date format using SQL.

Pls Can anyone help?

Ex:

> SELECT SLIVD FROM ;

SLIVD
----------
108090

Regards,
Pandian

Reply With Quote

---

Quick Navigation Feedback and Questions regarding the forums Top

• Site Areas
• Settings
• Private Messages
• Subscriptions
• Who's Online
• Search Forums
• Forums Home
• Forums
• Oracle Forums
  1. Oracle Database Administration
  2. Oracle Applications DBA
  3. Oracle Development
  4. Oracle Certification
  5. Oracle : How To
• Oracle Careers
  1. Oracle Positions Available
  2. Oracle Job Wanted
• Archives
  1. Forum Archives
• Other
  1. Feedback and Questions regarding the forums
  2. Obfuscation Unlimited

« Previous Thread | Next Thread »

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•  

• BB code is On
• Smilies are On
• [IMG] code is On
• [VIDEO] code is On
• HTML code is On

Forum Rules

• Contact Us
• DBAsupport.com Home Page
• Top

Click Here to Expand Forum to Full Width