| Subject | RE: [firebird-support] Re: Checking periods don't overlap | 
|---|---|
| Author | Steffen Heil | 
| Post date | 2004-06-15T11:41:35Z | 
Hi
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.
Regards,
Steffen
            > Just out of curiosity: How do you handle the days when time changesfrom/to summertime?
> (especially when changing from summertime to standard time again and youhave 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.
Regards,
Steffen