Not sure if this is a good place to post, but we're trying to reverse
engineer an Oracle database which has two fields for date & time. They don't
seem to be encoded using the standard Oracle date/time fields so we suspect
the developer has used some bespoke encoding system.

So I thought it would be a good challenge for somebody mathematically
minded.

The example I currently have is:

17th October 2008 encoded as 131598865
13:54:49 encoded as 221655296

I'll try and get some more examples.

Any help appreciated.

Thanks, Rob.

"Rob Nicholson" <rob.nicholson (AT) nospan (DOT) com> writes:
Hexadecimal: 0x07D80A11
And:
07D8 = 2008
0A = 10
11 = 17

Hexadecimal: 0x0D363100
And:
0D = 13
36 = 54
31 = 49


Phil

--
Christianity has such a contemptible opinion of human nature that it does
not believe a man can tell the truth unless frightened by a belief in God.
No lower opinion of the human race has ever been expressed.
-- Robert Green Ingersoll (1833-1899), American politician and scientist

"Rob Nicholson" <rob.nicholson (AT) nospan (DOT) com> writes:
Hexadecimal: 0x07D80A11
And:
07D8 = 2008
0A = 10
11 = 17

Hexadecimal: 0x0D363100
And:
0D = 13
36 = 54
31 = 49


Phil

--
Christianity has such a contemptible opinion of human nature that it does
not believe a man can tell the truth unless frightened by a belief in God.
No lower opinion of the human race has ever been expressed.
-- Robert Green Ingersoll (1833-1899), American politician and scientist

"Rob Nicholson" <rob.nicholson (AT) nospan (DOT) com> writes:
Hexadecimal: 0x07D80A11
And:
07D8 = 2008
0A = 10
11 = 17

Hexadecimal: 0x0D363100
And:
0D = 13
36 = 54
31 = 49


Phil

--
Christianity has such a contemptible opinion of human nature that it does
not believe a man can tell the truth unless frightened by a belief in God.
No lower opinion of the human race has ever been expressed.
-- Robert Green Ingersoll (1833-1899), American politician and scientist

"Rob Nicholson" <rob.nicholson (AT) nospan (DOT) com> writes:
Hexadecimal: 0x07D80A11
And:
07D8 = 2008
0A = 10
11 = 17

Hexadecimal: 0x0D363100
And:
0D = 13
36 = 54
31 = 49


Phil

--
Christianity has such a contemptible opinion of human nature that it does
not believe a man can tell the truth unless frightened by a belief in God.
No lower opinion of the human race has ever been expressed.
-- Robert Green Ingersoll (1833-1899), American politician and scientist

"Phil Carmody" <thefatphil_demunged (AT) yahoo (DOT) co.uk> wrote


Which means it's simply byte byte word format.

i.e., day + month << 8 + year << 16

decoding is in reverse:

day = date & 0xFF;
month = date >> 8 & 0xFF
year = date >> 16

"Phil Carmody" <thefatphil_demunged (AT) yahoo (DOT) co.uk> wrote


Which means it's simply byte byte word format.

i.e., day + month << 8 + year << 16

decoding is in reverse:

day = date & 0xFF;
month = date >> 8 & 0xFF
year = date >> 16

"Phil Carmody" <thefatphil_demunged (AT) yahoo (DOT) co.uk> wrote


Which means it's simply byte byte word format.

i.e., day + month << 8 + year << 16

decoding is in reverse:

day = date & 0xFF;
month = date >> 8 & 0xFF
year = date >> 16

"Phil Carmody" <thefatphil_demunged (AT) yahoo (DOT) co.uk> wrote


Which means it's simply byte byte word format.

i.e., day + month << 8 + year << 16

decoding is in reverse:

day = date & 0xFF;
month = date >> 8 & 0xFF
year = date >> 16

"Jon Slaughter" <Jon_Slaughter (AT) Hotmail (DOT) com> writes:
Not in C, it's not. + has higher precedence than <<.

Phil
--
Christianity has such a contemptible opinion of human nature that it does
not believe a man can tell the truth unless frightened by a belief in God.
No lower opinion of the human race has ever been expressed.
-- Robert Green Ingersoll (1833-1899), American politician and scientist