Subject | Re: [firebird-support] Re: Checking periods don't overlap |
---|---|
Author | Lester Caine |
Post date | 2004-06-15T12:17:36Z |
Steffen Heil wrote:
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
>>Just out of curiosity: How do you handle the days when time changesI would like to do that on the railway system, but the source data from
> 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.
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