At October 24, 2003, 14:43, Roland Volkmann wrote:

>but what about the night, when the clocks a set back from summer
>time (CEST) to winter time (CET) and we have two times the hour
>between 02:00 and 03:00 ??

>In environments where events have to be registered correctly (e.g. police) the
>terminology 02:01A for the first hour, and 02:01B for the second hour is used.
>And such data can't be stored to type TIMESTAMP, right?

No, you can't store values like 02:01A in a Timestamp. But you can do
other things. For instance, keep a record of a exact timestamp when
clocks moved. Then in all your queries, you can make things like:

SELECT db_time, 'A', ...
from table
where db_time < :clocks_moved_at

union

SELECT dbtime + 0.083333333333, 'B', ....
from table
where db_time >= :clocks_moved_at

Or you can write a view/sp that does this kind of query and select from
it all the time.

--
Milan Babuskov
http://fbexport.sourceforge.net