Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears ,
how are you i hope everyone in good health , we have an JDE Oracle Database and it stored the date as a numeric(18,0) i need to convert it to date Gregorian date i try it but it not work and i read some discussion about the date and did not work smooth with me
so if can some one help me in this ,
please see this date example :
date |
---|
114305 |
114307 |
114313 |
114327 |
114336 |
114357 |
115005 |
115011 |
115021 |
115025 |
this table should be a date .
and one more thing how can i convert the date to the numeric value ?!
thanks for all
THANKS FOR GIVEN INFORMATION