[GLLUG] Is there any sane reason to do this? (Database question.)

Justin Perreault 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:
> Days,DateIdent
> 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
do such.


More information about the GLLUG mailing list