Print Thread
TOracleTimestamp and time zone names
#36275 10/27/09 04:25 PM
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
L
Member
OP Offline
Member
L
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
TOracleTimstamp can return timezone offsets, but doesn't return timezone names. OCI can return them, using OCIDateTimeGetTimeZoneName(). Could it be added?


LDS
Re: TOracleTimestamp and time zone names
ldsandon #36285 10/28/09 10:32 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
I have added this to the list of enhancement requests.


Marco Kalter
Allround Automations
Re: TOracleTimestamp and time zone names
Marco Kalter #37624 03/18/10 09:27 AM
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
L
Member
OP Offline
Member
L
Joined: Jul 2003
Posts: 112
Fino Mornasco, Como, Italy
It would also be nice to be able to set timezone offsets as time zone names. For example I am building an interface to the Oracle scheduler, and I found that if you submit a job using the TZ name Oracle will automatically take into account daylight saving times, while if a TZ is specified as a numeric offset, it won't. Thereby if I want a job to be run on the actual TZ time I have to set is as a TZ name.


LDS

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.122s Queries: 15 (0.058s) Memory: 2.5028 MB (Peak: 3.0408 MB) Data Comp: Off Server Time: 2024-05-16 22:09:51 UTC
Valid HTML 5 and Valid CSS