Daniel

I recently posted raising similar questions about storing time values.
I see in this thread the advice was to store time as GMT (as well as
local perhaps) and let the higher level application translate back to
local time. I can understand this is a good/preferable way to go.

Further question is, however: how do you store time as GMT?!

Thanks
Will




<d.jimenez@c...> 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