-
SQL - Date Conversion
Hi,
We are using Oracle ERP in my organization. The Oracle JDE is web based application and database is Oracle 10g.
We create a sales order and enter the invoice date (SLIVD – field name). It’s posting to database in number format data type.
Pls can anyone help?
Ex:
The SLIVD (Invoice date) is given 24/12/2007 (front-end) and save it.
But, the date is stored in database ‘107358’. (Number format)
How to retrieve the date format from data base?
I have used query as follows:
------------------------------------------------------------------------------------------------------
>SELECT SLIVD FROM WHERE SLDOCO=206 ANS SLMCU=11090
Display:
>107289
Regards,
Pandian
-
well what does 107358 represent
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|