I hope every one in good health , and i need to know something about date if the date stored in our database as a number like this(115001,115002,115003,.......,,115046)
how we can convert it to date (year ,month , day ....) what is the formula & logically how it work .
we have Oracle ERP System , But i connect to the server database and read it by using SQL server and it is look like this format (115001,115002,115003) and when we use that formula it retrieve the correct data , but didn't understand it before until they explain it (hank you msolomov).
thank you msolomov and thank you all ,and i need to ask you after this formula if i need to convert the normal date to numeric value with the same logic that i get the date .
what i mean is revers the the formula to get the numeric value .
because i face an issue after convert it when i try to join the date withe the other table but have normal date and i need to trust after convert the date to the numeric value is the same so can any one help me in this
