Top "Timezone" questions

A time zone is a region on Earth that has a uniform, legally mandated standard time.

Parsing an ISO8601 date/time (including TimeZone) in Excel

I need to parse an ISO8601 date/time format with an included timezone (from an external source) in Excel/VBA, …

excel datetime vba timezone iso8601
Do unix timestamps change across timezones?

As the subject asks; do UNIX timestamps change in each timezone? For example, if I sent a request to another …

timezone unix-timestamp
The best way to synchronize client-side javascript clock with server date

I have a task to show digital clock (with minutes precision) on HTML page in some fixed timezone (MSK or …

javascript ajax timezone clock-synchronization
How to parse dates with -0400 timezone string in Python?

I have a date string of the form '2009/05/13 19:19:30 -0400'. It seems that previous versions of Python may have …

python datetime timezone
How to get Time Zone through IP Address in PHP

I want to get time zone through an IP Address in PHP. Actually, I have an application which will run …

php time timezone ip
How to get system timezone setting and pass it to pytz.timezone?

We can use time.tzname get a local timezone name, but that name is not compatible with pytz.timezone. In …

python timezone pytz
Which timestamp type should I choose in a PostgreSQL database?

I would like to define a best practice for storing timestamps in my Postgres database in the context of a …

postgresql timezone timestamp
How to add timezone into a naive datetime instance in python

I've got a datetime which has no timezone information. I'm now getting the timezone info and would like to add …

python datetime timezone pytz
Difference between UTC and GMT

Hi i have few queries regarding the Time zones: Can the time be captured in UTC alone? Is UTC -6 …

datetime timezone utc gmt