liuxd · April 14, 2019 22:17
diff --git a/set_tz.py b/set_tz.py
 import os, time

 os.environ['TZ'] = 'Pacific/Auckland'
 time.tzset()
diff --git a/set_tz_in_pgsql.py b/set_tz_in_pgsql.py
 import psycopg2

 conn_string = os.environ["DATABASE_URL"]
 conn = psycopg2.connect(conn_string)
 cur = conn.cursor()

 cur.execute("SET TIME ZONE 'Pacific/Auckland';")
 conn.commit()
 conn.close()

 # Timezone list in db: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones
diff --git a/show_tz_list.py b/show_tz_list.py
 import pytz
 pytz.all_timezones
	import os, time

	os.environ['TZ'] = 'Pacific/Auckland'
	time.tzset()
	import psycopg2

	conn_string = os.environ["DATABASE_URL"]
	conn = psycopg2.connect(conn_string)
	cur = conn.cursor()

	cur.execute("SET TIME ZONE 'Pacific/Auckland';")
	conn.commit()
	conn.close()

	# Timezone list in db: https://en.wikipedia.org/wiki/List_of_tz_database_time_zones