0
Good morning. I have to access the data in an Oracle database, where a field described as "validation date" has the following data:
DtValid
-------
115365
115364
115363
115362
115361
Does anyone know what kind of date this is? What format is this used? Thank you.
The guy in the column is Date? I have seen cases in some systems that for compatibility reasons with other legacy software, used columns of other types to save data ... personally I consider a bad practice, but it is possible. If it is a date, another possibility is to check the session NLS_DATE_FORMAT.
– Confundir
A guess would be days since a certain date (very old maybe) in reality DATE is recorded as seconds elapsed from a certain date (January 1, 4712 AC believe)
– Motta
The worst is that the field in the bank is a 6 position numeric.
– Marcelo Cannalonga