| Subject | Re: [firebird-support] Re: Does Firebird support DayLight Saving ? |
|---|---|
| Author | Milan Babuskov |
| Post date | 2003-10-25T06:52:44Z |
Milan Babuskov wrote:
select db_time + 0.0416666666, 'B', ...
1/24 = 0.0416666.
If you really want to get exactly one hour more, is even better to do
something like this:
select db_time + cast (1 as double precision) / cast (24 as double
precision), ...
--
Milan Babuskov
http://fbexport.sourceforge.net
> SELECT dbtime + 0.083333333333, 'B', ....Sorry, this should be:
select db_time + 0.0416666666, 'B', ...
1/24 = 0.0416666.
If you really want to get exactly one hour more, is even better to do
something like this:
select db_time + cast (1 as double precision) / cast (24 as double
precision), ...
--
Milan Babuskov
http://fbexport.sourceforge.net