Ping: Database Type People

[Coffee Warlord]

Have any of you ever encountered a date stored in a 5 digit numeric format that is NOT Julian format?

Examples of dates I'm seeing: 69367, 66185, 56079. All 5 digits, all with no way of deciphering. All I have is the raw SQL data to look at (I'm importing this data from an old program into a new application), and there ain't a single person who knows how the hell that translates.

If it helps. This information MIGHT be accurate. They've been importing some test clients into the new system, which stores dates sanely. Assuming they accurately entered the DOBs into the new system, that'd be the translation. God knows how.

69367: 11/29/1990
65335: 11/15/1979

[knolysis]

I don't know but both are 4,032 apart (4,032 days, 4,032 units). The only thing I can recommend is index from one of the known values to calculate what the others should be.

[Passacaglia]

Probably 0=1/1/1801

[Radii]

Clarion: Clarion Database Conversion, clarion database, database conversion (http://en.allexperts.com/q/Clarion-2368/Clarion-Database-Conversion-3.htm)



Clarion uses the number of days elapsed since December 28, 1800.


WTF?

[Drake]

Clarion: Clarion Database Conversion, clarion database, database conversion (http://en.allexperts.com/q/Clarion-2368/Clarion-Database-Conversion-3.htm)

:lol: :lol:

This sort of thing is one of the reasons that I keep working in database applications. There's just enough quirky shit that no one one the planet has any right to remember to always make it interesting.

And for the record, I heart Radii for that find. Brilliant.

[MikeVic]

Clarion: Clarion Database Conversion, clarion database, database conversion (http://en.allexperts.com/q/Clarion-2368/Clarion-Database-Conversion-3.htm)




WTF?

hahaha.