| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Timezone change for Query
On Mon, 15 Nov 1999 19:31:11 GMT, sbenitez_at_my-deja.com wrote:
>The only way I would know how to do it is you have to know your offset
>from GMT and do some sort of date/time conversion. We have this same
>problem, with trains crossing multiple time zones and tracking these
>trains in the correct time zone as the person looking at it. The only
>way we can do it is by storing the offset in a lookup table along with
>the user, and do our conversion from there. The procs which display
>the reports also make a call to a function that check if we are in
>daylight savings or not. Not the most pretty way, but it's effective.
You are correct, in Oracle there are no native facilities to do timezone conversion for every locale/region around the world.
The native TimeZone class in Java has an interesting implementation, where there are specific rules that are used to determine when (and if) Daylight Saving Time is observed. Then, a specific locale is a combination of the time offset from GMT, and the specific DST rule they observe. Implementation of this in SQL & PL/SQL is straightforward....the hard part is locating *accurate* information about the different DST rules around the world.
>
>In article <38300EDE.383A7A5_at_eurowings.de>,
> Thorsten Lau <lau_at_eurowings.de> wrote:
>> Hi,
>>
>> I have a nasty Problem.
>> I need to select rows from a table, that has date-fields in UTC( or
>> GMT), but I need do display it in local time.
>> Does anyone has an idea??
>>
>> Thanks,
>> Thorsten
>> --
>> Thorsten Lau | mailto:lau_at_eurowings.de
>> Eurowings AG | IT
>> Telefon | +49 231 9245 7624
>>
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Thanks!
Joel
Joel R. Kallman Oracle Service Industries
Columbus, OH http://govt.us.oracle.com jkallman@us.oracle.com http://www.oracle.com
 |
 |