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@talisys.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