|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
March 12th, 2007, 06:06 PM
|
|||
|
|||
|
DB2 UDB SQL UTC to Local Time
I have an application that stores the time stamp of the event in UTC format. I need to convert that UTC to local time of the server for reporting purposes. I tried to come up with an algorithm using CURRENT TIMEZONE. But I'm not having much luck there. You would think that you would subtract the time zone offset from the time stamp but I get a sql error. Any help would be appreciated.
|
|
| Viewing: Dev Shed Forums > Databases > DB2 Development > DB2 UDB SQL UTC to Local Time |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
