Re: DateTime Calculations

melrose_2_at_hotmail.com wrote:
>
> We are implementing a GLOBAL application that stores all datetime values
> in GMT. We can NOT use the supplied NEW_TIME function because it only
> covers the Eastern Hemisphere. I always know the GMT HOURLY OFFSET of the
> user attempting to update the database ...MY PROBLEM is ....... How do I
> increment or decrement and ORACLE DATE column by an integer number of
> hours ?? Does any one have a PL/SQL function for doing this ?? ANY help
> in this matter would be GREATLY appreciated !! TIA......
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet

Date/Time calculations are done in days, so to add an hour:

date_column + (1/24)

or to subtract an hour:

date_column - (1/24)

-- 
Allen Kirby			
AT&T Information Technology Services
Alpharetta, GA.
The views expressed here are mine, not my employers.