Store all times in UTC (or GMT, or UTC, or whatever you call it this
week). Do all conversions on display (outside of the DB).

On Fri, 2005-04-08 at 11:40 +1000, Daniel Jimenez wrote:
>
> Hi everyone,
>
> In the near future we are to develop a DB app, which must keep a very
> accurate audit trail, which as you can imagine includes date and time. Thus,
> their exist the potential for corruption (for that one hour when time
> travels back for daylight savings), so before reinventing the wheel, I would
> really appreciate if you could share your experience or suggestion regarding
> this.
>
> Thank you in advance
>
> daniel
>
> ____________________________
> Comvision Pty. Ltd.
>
> www.comvision.net.au
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>