Oracle Date Field Question

[Clay]

I'm trying to determine what the common date equivalent value is for the following numeric field in an Oracle (version 9i I think) database. The field name is "sdate" and the value is: 8911374

That's all I know as it is from a very undocumented system that just now fell on my plate.

My guesses initially were that it was in Julian format but that doesn't seem right (Julian common era would equate to May 30, 1968).

Any other ideas? Thanks.

[de><ta]

The number format makes it highly unlikely that it does fit into any conventional date system.

ie. Looking for two consecutive digits which are less then 12 or 31 fails.

It has 7 digits so if it were a representation of a date system it would need atleast 4 digits to represent the months and the days leaving 3 digits for years?

Have you traced were this sdate variable is being used?
sdate: start date, stop date, sync date?

Hate poorly comented code.

[Banko]

I'm trying to determine what the common date equivalent value is for the following numeric field in an Oracle (version 9i I think) database. The field name is "sdate" and the value is: 8911374

That's all I know as it is from a very undocumented system that just now fell on my plate.

My guesses initially were that it was in Julian format but that doesn't seem right (Julian common era would equate to May 30, 1968).

Any other ideas? Thanks.
Can it be encrypted? What the reason for doing that I don't know.

[DaveW]

Oracle stores dates relative to January 1, 4712 BC. That still results in a wierd value though.

[Clay]

Thanks for the ideas so far guys. At this point I don't think I can have access to trace when that value is assigned. Encryption is possible I suppose but doubtful I would think. Yeah, still a very weird date value. I would expect it to translate to a date within the past few months or so.