topic Re: Finding timezone from zipcode in Application Development and Automation Discussions

Finding timezone from zipcode

Former Member — Tue, 24 Apr 2007 09:17:30 GMT

Hello All,

There is a requirement in my application, where in

i have to find the timezone of a location based on the zip code

entered for that location.

Kindly let me know whether any function module exists for the same.

Thanks in advance,

Rashmi.

Former Member — Tue, 24 Apr 2007 09:21:58 GMT

Query the table T5UZC to get the Coutry and Region for a zip code.

Then you can use the FM TZ_LOCATION_TIMEZONE to get you the time zone for a country and region combination.

Regards,

Ravi

Former Member — Tue, 24 Apr 2007 09:22:13 GMT

chk the table TTZ5Z

null

Former Member — Tue, 24 Apr 2007 11:43:09 GMT

Hi,

thanks, but am not able to find any data in this table, i gave data in all

the 3 input parameters.

Thanks,

RAshmi.

Former Member — Tue, 24 Apr 2007 11:51:27 GMT

Query the table T5UZC to get the Coutry and Region for a zip code.

Then you can use the FM TZ_LOCATION_TIMEZONE to get you the time zone for a country and region combination.

U have the zipcode. goto T5UZC and try the below ways... one will work...

1) enter zipcode in T5UZC-ZIPHI and fetch LAND1 & REGIO fields. Using TZ_LOCATION_TIMEZONE get the time zone by passing LAND1 & REGIO fields.

2) enter zipcode in T5UZC-ZIPLO and fetch LAND1 & REGIO fields. Using TZ_LOCATION_TIMEZONE get the time zone by passing LAND1 & REGIO fields.

of these 2 combinations 1 of them will work fine in ur case.