Given geographic coordinates, how does oracle determine the correct timezone?
From: Gus Spier <gus.spier_at_gmail.com>
Date: Wed, 14 Mar 2018 21:03:08 -0400
Message-ID: <CAG8xnieb7+6q37Ei9M1uoag=cNTCM1sXJfDzBaXx=LS10PQKaw_at_mail.gmail.com>
The task is to supply the local time for a transaction when all we have are the geographic coordinates and UTC (Greenwich Mean Time). Is there no internal table that we can exploit?
If not, then much skull sweat will be expended adapting tz_world (or its successors) to the purpose.
Any ideas will be appreciated
Date: Wed, 14 Mar 2018 21:03:08 -0400
Message-ID: <CAG8xnieb7+6q37Ei9M1uoag=cNTCM1sXJfDzBaXx=LS10PQKaw_at_mail.gmail.com>
The task is to supply the local time for a transaction when all we have are the geographic coordinates and UTC (Greenwich Mean Time). Is there no internal table that we can exploit?
If not, then much skull sweat will be expended adapting tz_world (or its successors) to the purpose.
Any ideas will be appreciated
Regards,
Gus
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 15 2018 - 02:03:08 CET