Not to worry, i got it.


select (mydate+mytime)+(0.04166666666666666666) from mytable

adds an hour

--- In firebird-support@yahoogroups.com, "donjules2k" <giulio@g...> wrote:
> Hi,
>
> What is the easiest way of adding an hour to a load of date and time
> fields. I currently have them as two seperate fields date, time.
>
> Thanks.
>
> Giulio