Skip to Main Content

Breadcrumb

Dev Live Dev Intro

We are celebrating Developers at AskTOM. We welcome Developers of all levels of experience to join us at our FREE Developer Live events coming in August and September. Just click on the left to register today! If you are brand new to Database Technology, then we also have got you covered. Just click on the right for your comprehensive FREE training program to kick start your Oracle Database Development journey!

Question and Answer

Connor McDonald

Thanks for the question, Ravikanth.

Asked: September 09, 2020 - 7:02 pm UTC

Answered by: Connor McDonald - Last updated: September 10, 2020 - 7:00 am UTC

Category: Database Development - Version: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

Viewed 100+ times

You Asked

Hello,

Is there any DB utility/custom code/Java stored procedure to find a timezone with an address as an input (City, State, country).

Thanks,
Ravi B

and we said...

Not natively within the database.

You could look at accessing a paid-for service via a REST call from the database, or perhaps something like

https://timezonedb.com/

and download the data periodically to a local table and use that.

More to Explore

PL/SQL

Check out more PL/SQL tutorials on our LiveSQL tool.