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

Posting Permissions

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



Click Here to Expand Forum to Full Width