08-04-2009, 04:21 PM | #1 | ||
Head Coach
Join Date: Oct 2002
Location: Colorado Springs
|
Ping: Database Type People
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 |
||
08-04-2009, 05:04 PM | #2 |
n00b
Join Date: Aug 2007
|
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.
|
08-04-2009, 05:09 PM | #3 |
Coordinator
Join Date: Oct 2000
Location: Big Ten Country
|
Probably 0=1/1/1801
Last edited by Passacaglia : 08-04-2009 at 05:09 PM. |
08-04-2009, 05:14 PM | #4 | |
Head Coach
Join Date: Jul 2001
|
Clarion: Clarion Database Conversion, clarion database, database conversion
Quote:
WTF? |
|
08-04-2009, 07:29 PM | #5 | |
assmaster
Join Date: Feb 2001
Location: Bloomington, IN
|
Quote:
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. |
|
08-04-2009, 10:08 PM | #6 | |
Head Coach
Join Date: Mar 2003
Location: Hometown of Canada
|
Quote:
hahaha. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
Thread Tools | |
|
|