TOracleTimestamp and time zone names

[ldsandon]

TOracleTimstamp can return timezone offsets, but doesn't return timezone names. OCI can return them, using OCIDateTimeGetTimeZoneName(). Could it be added?

 

[Marco Kalter]

I have added this to the list of enhancement requests.

 

[ldsandon]

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.