# timezone A set of rules relating local time to UTC for a place or region, used to convert timestamps to and from local time. This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## Home Assistant timezone and configuration override issues DevFeed: [Home Assistant timezone and configuration override issues]() Original publisher: [Read original article]() Author: Nicolas Fränkel Published: 2026-07-05T00:00:00Z Content type: opinion Language: en Sources: [Nicolas Fränkel]() Topics: [Home Assistant](), [timezone](), [Automation](), [bug](), [configuration](), [YAML]() Tags: [automation](), [bugs](), [config](), [home-assistant](), [locale](), [technical](), [timezone](), [user-experience](), [yaml]() ### AI overview The author describes Home Assistant shutter automations that ran an hour late during summer time because the instance timezone appeared as Paris/+1. Overriding the timezone in configuration removed UI-set settings, requiring all settings to be specified again in YAML. ### Source excerpt Last year, I motorized the rolling shutters on the southern façade of my apartment. My idea was to manage them via Home Assistant. I had a couple of automations in mind: In the evening, roll down the shutters of my bedroomIn the morning:If it's too hot outside, roll down all shuttersIf it's too cold outside, roll down all shuttersIn other cases, roll up all shutters but my bedroom's Living in France, I added the official Météo France integration. ## How to render timestamp with a timezone that is different from current? DevFeed: [How to render timestamp with a timezone that is different from current?]() Original publisher: [Read original article]() Author: depesz Published: 2026-01-27T09:25:04Z Content type: tutorial Language: en Sources: [select \* from depesz;]() Topics: [timezone](), [PostgreSQL](), [DateTime]() Tags: [formatting](), [how-to](), [irc](), [postgresql](), [timestamptz](), [timezone](), [to-char](), [uncategorized](), [utc]() ### AI overview A PostgreSQL tutorial explaining why timestamptz values are displayed in the client's local timezone and how to render a timestamp with an offset for another timezone. It presents a custom function that returns text, preserves the client timezone, and optionally applies to_char formatting. ### Source excerpt This question appeared on IRC, and while I wasn't there while it happened, it caught my eye: " Can I not render this with timezone offset: select '2026-01-09 04:35:46.9824-08'::timestamp with time zone at time zone 'UTC'; " Returns '2026-01-09 12:35:46.9824' which is without the offset. Let's see what can be done about it. First, let's ... Continue reading "How to render timestamp with a timezone that is different from current?" ## One timezone for everything: k8tz and the Jakarta timestamp problem DevFeed: [One timezone for everything: k8tz and the Jakarta timestamp problem]() Original publisher: [Read original article]() Published: 2024-11-20T00:00:00Z Content type: article Language: en Sources: [Andika Ahmad Ramadhan -- Blog]() Topics: [Kubernetes admission controller](), [timezone](), [certificates](), [TLS (Transport Layer Security)](), [elasticsearch]() Tags: [certificates](), [elasticsearch](), [kubernetes-admission-controller](), [timezone](), [tls]() ### AI overview The article explains how k8tz applies Asia/Jakarta to Kubernetes pods through an admission controller, allowing public images such as Fluentd and Elasticsearch to use the platform timezone without image changes. It also describes three upstream patches for cert-manager support, certificate rotation without restarts, and configurable initContainer names. ### Source excerpt How we used k8tz to force Asia/Jakarta onto public images like Fluentd and Elasticsearch, and the three patches I sent upstream. ## How do I find out my timezone in Linux? DevFeed: [How do I find out my timezone in Linux?]() Original publisher: [Read original article]() Author: Vivek Gite Published: 2024-04-06T01:06:44Z Content type: tutorial Language: en Sources: [nixCraft: Linux Tips, Hacks, Tutorials, And Ideas In Blog Format (RSS/FEED)]() Topics: [Linux](), [timezone](), [Command-line interface](), [systemd](), [Unix](), [DateTime]() Tags: [command-line](), [easy](), [environment-variables](), [grep-command](), [linux](), [systemd](), [timedatectl](), [timezone](), [unix]() ### AI overview A practical Linux tutorial explaining how to inspect the configured system and user time zones. It covers timedatectl on systemd-based distributions, timezone files, environment variables, and command-line utilities such as grep, ls, cat, less, and date. ### Source excerpt You can find the timezone in Linux using the command line. The easiest way to do this is to type the "timedatectl" command and look for the "timezone" line when using modern Linux distros with systemd. There are other commands and ways to temporarily switch to a new timezone for date calculations. Love this? sudo share_on: Twitter - Facebook - LinkedIn - Whatsapp - Reddit The post How do I find out my timezone in Linux? appeared first on nixCraft. ## PostgreSQL DevFeed: [PostgreSQL]() Original publisher: [Read original article]() Author: Derek Lee Published: 2022-03-01T00:00:00Z Content type: tutorial Language: en Sources: [art and science of coding]() Topics: [PostgreSQL](), [Databases](), [SQL](), [configuration](), [timezone](), [JSON]() Tags: [configuration](), [database](), [dev-recipes](), [installation](), [json](), [postgresql](), [psql](), [setup](), [sql](), [timezone](), [troubleshooting]() ### AI overview A reference guide to PostgreSQL installation, database and user management, SQL statements, configuration, time zone settings, psql commands, JSON fields, and troubleshooting connection problems. ### Source excerpt Installation / Setup ## Year in review 2020 DevFeed: [Year in review 2020]() Original publisher: [Read original article]() Author: info@jeroenmols.com (Jeroen Mols) Published: 2021-01-05T00:00:00Z Content type: opinion Language: en Sources: [Jeroen Mols]() Topics: [Code](), [timezone]() Tags: [blogs](), [code](), [events](), [mastodon](), [remote-work](), [review](), [twitter](), [year-in-review]() ### AI overview A personal review of 2020 covering remote work, family life, health, creative projects, professional speaking and writing, community contributions, and plans for 2021. ### Source excerpt Well... I don't really know where to start this time. 2020 was quite the rollercoaster, with many downs... but fortunately also a few amazing ups. Let's focus on the good stuff. ## Handling Dates & Times in SQLite DevFeed: [Handling Dates & Times in SQLite]() Original publisher: [Read original article]() Published: 2020-09-04T16:35:01Z Content type: tutorial Language: en Sources: [Blogs on Ryan Harter]() Topics: [SQLite](), [Databases](), [DateTime](), [SQL](), [timezone](), [Kotlin]() Tags: [database](), [kotlin](), [sql](), [sqlite](), [time](), [timezone]() ### AI overview The article examines how to store dates and times in SQLite for a Kotlin app using Room. It explains that SQLite has no dedicated DateTime type and discusses problems with storing timestamps as Unix-epoch milliseconds, including timezone handling and query support. ### Source excerpt As I've been refactoring a fairly large section of Pigment, my coloring book app for adults, I came across some SQL code which I haven't touched in a very long time and didn't seem quite right. Part of Pigment's large library of coloring books and pages are the Daily books, which are a different book each month in which a new page is released each day. The day's page is free only for the day (for non-subscribers), and then reverts to being locked once the next page is released. Users can unlock a page forever by simply starting a coloring project with it while it's free, but there is a limited window in which it's available. ## Postgres Datatypes - The ones you're not using. DevFeed: [Postgres Datatypes - The ones you're not using.]() Original publisher: [Read original article]() Author: Map Published: 2014-05-07T20:55:56Z Content type: article Language: en Sources: [Craig Kerstiens]() Topics: [Databases](), [timezone](), [DateTime](), [Gin](), [Extension]() Tags: [extension](), [gin](), [postgres](), [postgresql](), [timestamptz](), [timezone](), [uuid]() ### AI overview This article discusses less commonly used Postgres data types, including hstore, range types, timestamp with timezone, and UUIDs. It describes practical uses such as storing key-value data, constraining ranges, handling time zones, and supporting scalable identifiers. ### Source excerpt Postgres has a variety of datatypes, in fact quite a few more than most other databases. Most commonly applications take advantage of the standard ones - integers, text, numeric, etc. Almost every application needs these basic types, the rarer ones may be needed less frequently. And while not needed on every application when you do need them they can be an extremely handy. So without further ado let's look at some of these rarer but awesome types. hstore Yes, I've talked about this one before, yet still not enough people are using it. Of this list of datatypes this is one that could also have benefit for most if not all applications. Hstore is a key-value store directly within Postgres. This means you can easily add new keys and values (optionally), without haveing to run a migration to setup new columns. Further you can still get great performance by using Gin and GiST indexes with them, which automatically index all keys and values for hstore. It's of note that hstore is an extension and not enabled by default. If you want the ins and outs of getting hands on with it, give the article on Postgres Guide a read. Range types If there is ever a time where you have two columns in your database with one being a from, another being a to, you probably want to be using range types. Range types are just that a set of ranges. A super common use of them is when doing anything with calendaring. The place where they really become useful is in their ability to apply constraints on those ranges. This means you can make sure you don't have overlapping time issues, and don't have to rebuild heavy application logic to accomplish it. Timestamp with Timezone Timestamps are annoying, plain and simple. If you've re-invented handling different timezones within your application you've wasted plenty of time and likely done it wrong. If you're using plain timestamps within your application further there's a good chance they dont even mean what you think they mean. Timestamps with timezone o