Subject Re: Dates and Times
Author donjules2k
Not to worry, i got it.

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

adds an hour

--- In, "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