Subject Re: [firebird-support] Re: Checking periods don't overlap
Author Lester Caine
Steffen Heil wrote:

>>Just out of curiosity: How do you handle the days when time changes
> from/to summertime?
>>(especially when changing from summertime to standard time again and you
> have two times 2 a.m.?)
>
> I don't know how he does it.
> But in a database, you should never store any date/time in a format which is
> sensitive to summertime. Use UTC or whatever you want.
> The output/display function needs to translate this to summer/winter-time.

I would like to do that on the railway system, but the source data from
the 'train services database' is already messed up :)

In office environments running 8am to 6pm there is no need for the
complexity ( yet ).

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services