Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> DateTime Calculations
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 UsenetReceived on Fri Dec 05 1997 - 00:00:00 CST