[GLLUG] Is there any sane reason to do this? (Database question.)
justinperreault at dl-jp.com
Wed Oct 15 11:41:46 UTC 2014
On Tue, 2014-10-07 at 20:05 +0100, John Winters wrote:
> I'm extracting data from a legacy (sort of - still actively sold) system
> which has the following table:
> 2000-01-03 00:00:00.000,1
> 2000-01-05 00:00:00.000,2
> Then whenever another table in the database would normally have a column
> of type "Date" it has column of type "Integer", which is used to index
> into this table.
> Is there a good design reason to do this?
The only idea I can come up with is if records needed to have the date
obfuscated for some reason.
Not being a DB expert myself I can only guess there are better ways to
More information about the GLLUG