Re: creating audit tables

12/31/9999 would be Y10K problem. :)

Dunno about you but I sorta don't care if somebody has to rewrite my app
8000 years from now. :)

Ian Harding wrote:

> Oh yes. I do that a lot for attributes that need a history (last name,
> which changes when you get married, etc) It is a bit more complicated
> for queries though, since I use null to indicate an unknown end date
> instead of the Y2K problem solution below.
>
> -Ian
>
>
>>>>William Yu <wyu(at)talisys(dot)com> 10/15/04 12:46 PM >>>
>
> Have you thought about unifying the audit + the current table and add
> from/to datestamps for every record?
>
> Example:
>
> from_dt to_dt value
> 9/1/2004 9/30/2004 ABC
> 9/30/2004 10/5/2004 XYZ
> 10/6/2004 12/31/9999 123