# 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.

## Week Notes 26#46

DevFeed: [Week Notes 26#46](<https://devfeed.tech/articles/week-notes-26-46-134654.md>)

Original publisher: [Read original article](<https://www.jvt.me/week-notes/2026/46/>)

Author: Jamie Tanna

Published: 2026-11-15T21:01:51Z

Content type: article

Language: en

Sources: [Jamie Tanna](<https://devfeed.tech/sources/articles-on-jamie-tanna-software-engineer.md>)

Topics: [User interface design](<https://devfeed.tech/topics/ui-design.md>), [timezone](<https://devfeed.tech/topics/timezone.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [apex](<https://devfeed.tech/tags/apex.md>), [assessment](<https://devfeed.tech/tags/assessment.md>), [comedy](<https://devfeed.tech/tags/comedy.md>), [driving](<https://devfeed.tech/tags/driving.md>), [family](<https://devfeed.tech/tags/family.md>), [freezer](<https://devfeed.tech/tags/freezer.md>), [github](<https://devfeed.tech/tags/github.md>), [godzilla](<https://devfeed.tech/tags/godzilla.md>), [infra](<https://devfeed.tech/tags/infra.md>), [linkedin](<https://devfeed.tech/tags/linkedin.md>), [podcast](<https://devfeed.tech/tags/podcast.md>), [storm](<https://devfeed.tech/tags/storm.md>), [tax-return](<https://devfeed.tech/tags/tax-return.md>), [ted](<https://devfeed.tech/tags/ted.md>), [timezone](<https://devfeed.tech/tags/timezone.md>), [week-notes](<https://devfeed.tech/tags/week-notes.md>), [wildcard](<https://devfeed.tech/tags/wildcard.md>)

### AI overview

A long week included comedy shows, family time, and progress on a self-assessment tax return. The author also described recent blog and infrastructure changes: improving the GitHub logo's contrast in posts, stopping SVG syndication to LinkedIn because it does not support them, fixing redirects, and making `tz` configurable instead of hard-coding timezone options. In Apex Legends, the new Godzilla mode was enjoyable, with Storm Point's scale and verticality highlighted in Wildcard. The author watched The Expanse (Season 5), Ghosts (Seasons 1 and 2), Nobody Wants This (Season 3), and In the Grey (2026).

### Source excerpt

A bit of a long week 🥱 Got the new freezer delivered - but not yet got it all set up and ready - but at least now we're able to get our Christmas Cook delivery in a couple of weeks A good week for comedy: Was a fun, chaotic night on Monday at Sam Campbell Also a fun time at Fatiha El-Ghorri on Wednesday Discovered the very funny Craig Simons - very good tribute! Wrote about my new theme, and some of the changes I've done recently, as well as this week: Improving the contrast for the GitHub logo on blog posts I post Not syndicating SVGs to LinkedIn, as they aren't supported Fixing up some redirects + improving things on my infra Made tz configurable, instead of baking timezone options into the tool Ended up missing the green bin collection, clearing out the vegetable draw 😬 Had a lovely day today seeing my sister and family It was a bit of a day of driving but worth it 🥰 Breaking Change is a perfect podcast to listen for long drives - Justin's great! Did most of my self-assessment tax return, and not happy with the numbers 😅 Playing: (No Blue Prince) Kingshot (per usual) Apex Legends The new Godzilla mode is very fun, and the scale + verticality in Storm Point is excellent in Wildcard Watched: The Expanse (Season 5) (No Ted Lasso (Season 4)) Ghosts (Season 1) Finding some of the storylines second hand stressful - wouldn't want to ?? Ghosts (Season 2) Nobody Wants This (Season 3) In the Grey (2026)

## Microsoft's Canada timezone troubles leave admins fixing calendars, pretending they're in Bogota

DevFeed: [Microsoft's Canada timezone troubles leave admins fixing calendars, pretending they're in Bogota](<https://devfeed.tech/articles/microsoft-s-canada-timezone-troubles-leave-admins-fixing-calendars-pretending-they-re-in-bogota-121627.md>)

Original publisher: [Read original article](<https://blog.adafruit.com/2026/11/06/microsofts-canada-timezone-troubles-leave-admins-fixing-calendars-pretending-theyre-in-bogota/>)

Author: Anne Barela

Published: 2026-11-06T21:16:26Z

Content type: news

Language: en

Sources: [Adafruit Industries](<https://devfeed.tech/sources/adafruit-industries-makers-hackers-artists-designers-and-engineers.md>)

Topics: [timezone](<https://devfeed.tech/topics/timezone.md>), [Microsoft](<https://devfeed.tech/topics/microsoft.md>), [microsoft 365](<https://devfeed.tech/topics/microsoft-365.md>)

Tags: [calendar](<https://devfeed.tech/tags/calendar.md>), [canada](<https://devfeed.tech/tags/canada.md>), [computers](<https://devfeed.tech/tags/computers.md>), [daylight-savings-time](<https://devfeed.tech/tags/daylight-savings-time.md>), [fabric](<https://devfeed.tech/tags/fabric.md>), [meetings](<https://devfeed.tech/tags/meetings.md>), [microsoft](<https://devfeed.tech/tags/microsoft.md>), [on-prem](<https://devfeed.tech/tags/on-prem.md>), [operating-system](<https://devfeed.tech/tags/operating-system.md>), [outlook](<https://devfeed.tech/tags/outlook.md>), [pages](<https://devfeed.tech/tags/pages.md>), [power-automate](<https://devfeed.tech/tags/power-automate.md>), [powershell](<https://devfeed.tech/tags/powershell.md>), [reddit](<https://devfeed.tech/tags/reddit.md>), [schedules](<https://devfeed.tech/tags/schedules.md>), [sysadmin](<https://devfeed.tech/tags/sysadmin.md>), [time-zones](<https://devfeed.tech/tags/time-zones.md>), [timezone](<https://devfeed.tech/tags/timezone.md>), [users](<https://devfeed.tech/tags/users.md>), [workaround](<https://devfeed.tech/tags/workaround.md>)

### AI overview

After affected parts of British Columbia, Alberta, and Manitoba stopped changing clocks on November 1, some Microsoft services continued to produce wrong times or broken schedules. In Outlook, switching to the new Canadian time zone does not update existing calendar entries, so later meetings can be an hour off. Only the organizer can fix a shared meeting; changing a recurring meeting's zone resets occurrences that were moved, which must then be recreated. Microsoft says a PowerShell cmdlet for non-recurring meetings is coming, while a recurring-meeting fix remains in development. Temporary workarounds in Power Automate and Fabric use other places with matching UTC offsets: Saskatchewan, Arizona, or Bogota for Manitoba. SharePoint On-Prem is scheduled to receive correct zones November 10, and a Power Pages fix is slated for December 12. This is based on the supplied excerpt.

### Source excerpt

Carly Page at The Register reports on what happened when parts of Canada stopped changing their clocks. As of November 1, affected areas of British Columbia, Alberta, and Manitoba are permanently on UTC-07:00, UTC-06:00 and UTC-05:00. Microsoft's software hasn't entirely caught up, so some customers are seeing wrong times and broken schedules. Outlook is the [...]

## Ubuntu refreshes time zone data for Canadian clock changes

DevFeed: [Ubuntu refreshes time zone data for Canadian clock changes](<https://devfeed.tech/articles/ubuntu-refreshes-time-zone-data-for-canadian-clock-changes-120875.md>)

Original publisher: [Read original article](<https://www.omgubuntu.co.uk/2026/11/ubuntu-canada-timezone-changes-2026>)

Author: Joey Sneddon

Published: 2026-11-05T12:45:00Z

Content type: news

Language: en

Sources: [OMG! Ubuntu](<https://devfeed.tech/sources/omg-ubuntu.md>)

Topics: [timezone](<https://devfeed.tech/topics/timezone.md>), [Ubuntu](<https://devfeed.tech/topics/ubuntu.md>), [canonical](<https://devfeed.tech/topics/canonical.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [bug-fixes](<https://devfeed.tech/tags/bug-fixes.md>), [canada](<https://devfeed.tech/tags/canada.md>), [canonical](<https://devfeed.tech/tags/canonical.md>), [clocks](<https://devfeed.tech/tags/clocks.md>), [database](<https://devfeed.tech/tags/database.md>), [distributions](<https://devfeed.tech/tags/distributions.md>), [install](<https://devfeed.tech/tags/install.md>), [linux](<https://devfeed.tech/tags/linux.md>), [linux-mint](<https://devfeed.tech/tags/linux-mint.md>), [lts](<https://devfeed.tech/tags/lts.md>), [news](<https://devfeed.tech/tags/news.md>), [os](<https://devfeed.tech/tags/os.md>), [refresh](<https://devfeed.tech/tags/refresh.md>), [releases](<https://devfeed.tech/tags/releases.md>), [time](<https://devfeed.tech/tags/time.md>), [tooling](<https://devfeed.tech/tags/tooling.md>), [tzdata](<https://devfeed.tech/tags/tzdata.md>), [ubuntu](<https://devfeed.tech/tags/ubuntu.md>), [utc](<https://devfeed.tech/tags/utc.md>)

### AI overview

Canonical updated Ubuntu's `tzdata` package to reflect permanent time changes in parts of Canada: British Columbia moved to UTC−07 on 9 March 2026, the Northwest Territories to UTC−06 on 21 August, and Manitoba to UTC−05 on 31 October. These changes prevent the usual November clock rollback in those locations. `tzdata` supports local system time and time or offset calculations by apps and tools. Some tooling uses ICU: Ubuntu 24.04 LTS and later provide it through `tzdata-icu`, while 20.04 and 22.04 include it in the `tzdata` update. Users receive the changes through system updates; Ubuntu 14.04 LTS requires the ESM add-on.

### Source excerpt

This time of the year, clocks spring forward and fall back across the globe, but some places are making permanent changes - and Ubuntu needs to keep pace. Over recent weeks, Canonical has refresh Ubuntu's system time zone database package tzdata on all supported releases to ensure the system reflects the local time in parts of Canada, where: The system needs to show the right time for obvious reasons (alarms, calendar alerts, knowing when you need to go to bed), but some apps and tooling rely on the tzdata package when trying to calculate times and offsets. Thus, it's helpful [...] You're reading Ubuntu refreshes time zone data for Canadian clock changes, a blog post from OMG! Ubuntu. Do not reproduce elsewhere without permission.

## What's new in ClickStack - September and October '26

DevFeed: [What's new in ClickStack - September and October '26](<https://devfeed.tech/articles/what-s-new-in-clickstack-september-and-october-26-115492.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/whats-new-in-clickstack-october-2026>)

Author: The ClickStack Team

Published: 2026-11-03T19:09:52Z

Content type: release

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [releases](<https://devfeed.tech/topics/releases.md>), [Prometheus](<https://devfeed.tech/topics/prometheus.md>), [OpenTelemetry](<https://devfeed.tech/topics/opentelemetry.md>), [health check](<https://devfeed.tech/topics/health-check.md>), [Grafana](<https://devfeed.tech/topics/grafana.md>), [timezone](<https://devfeed.tech/topics/timezone.md>)

Tags: [about](<https://devfeed.tech/tags/about.md>), [added](<https://devfeed.tech/tags/added.md>), [agent](<https://devfeed.tech/tags/agent.md>), [agentic](<https://devfeed.tech/tags/agentic.md>), [agents](<https://devfeed.tech/tags/agents.md>), [alerts](<https://devfeed.tech/tags/alerts.md>), [collector](<https://devfeed.tech/tags/collector.md>), [dashboard](<https://devfeed.tech/tags/dashboard.md>), [explorer](<https://devfeed.tech/tags/explorer.md>), [improvements](<https://devfeed.tech/tags/improvements.md>), [list](<https://devfeed.tech/tags/list.md>), [logs](<https://devfeed.tech/tags/logs.md>), [october](<https://devfeed.tech/tags/october.md>), [query](<https://devfeed.tech/tags/query.md>), [releases](<https://devfeed.tech/tags/releases.md>), [search](<https://devfeed.tech/tags/search.md>), [trace](<https://devfeed.tech/tags/trace.md>), [tracing](<https://devfeed.tech/tags/tracing.md>), [type](<https://devfeed.tech/tags/type.md>), [what-s-new](<https://devfeed.tech/tags/what-s-new.md>)

### AI overview

ClickStack v2.39-v2.42 added interactive ad hoc dashboard filters, expanded PromQL across chart types and the dashboards API, and query attribution that identifies the ClickStack surface responsible for ClickHouse load. Dashboard updates include required and single-select variables, saved relative time ranges, and PromQL heatmap modes; PromQL remains experimental and requires enablement, with ClickHouse 26.8 or newer recommended for self-managed servers. Search, trace, and alert workflows gained filtering, trace logs, chart-explorer alerts, and richer webhook validation and templates. The collector now offers opt-in StatsD and span-metrics components configured through a custom pipeline. For authenticated self-hosted deployments, upgrades require explicitly setting EXPRESS_SESSION_SECRET.

### Source excerpt

The September and October ClickStack releases bring ad hoc dashboard filters, PromQL for every chart type, ClickStack query tracing, a Trace logs tab, alerts from the chart explorer, and a long list of search page and collector improvements.

## Rejoice, leap seconds are dead!

DevFeed: [Rejoice, leap seconds are dead!](<https://devfeed.tech/articles/rejoice-leap-seconds-are-dead-109152.md>)

Original publisher: [Read original article](<https://www.jeffgeerling.com/blog/2026/rejoice-the-utc-leap-second-is-dead/>)

Author: jeff@jeffgeerling.com (Jeff Geerling)

Published: 2026-10-30T14:00:00Z

Content type: article

Language: en

Sources: [Jeff Geerling](<https://devfeed.tech/sources/jeff-geerling.md>)

Topics: [timezone](<https://devfeed.tech/topics/timezone.md>)

Tags: [2016](<https://devfeed.tech/tags/2016.md>), [2022](<https://devfeed.tech/tags/2022.md>), [astronomy](<https://devfeed.tech/tags/astronomy.md>), [aws](<https://devfeed.tech/tags/aws.md>), [bipm](<https://devfeed.tech/tags/bipm.md>), [clock](<https://devfeed.tech/tags/clock.md>), [clocks](<https://devfeed.tech/tags/clocks.md>), [daylight-saving-time](<https://devfeed.tech/tags/daylight-saving-time.md>), [earth](<https://devfeed.tech/tags/earth.md>), [leap-second](<https://devfeed.tech/tags/leap-second.md>), [nist](<https://devfeed.tech/tags/nist.md>), [time](<https://devfeed.tech/tags/time.md>), [utc](<https://devfeed.tech/tags/utc.md>), [youtube](<https://devfeed.tech/tags/youtube.md>)

### AI overview

The CGPM's Resolution 5 ends leap seconds in UTC: from May 20, 2027, UTC will no longer gain or lose seconds, and may drift from Earth-rotation time (UT1) by up to an hour. The source says the change was made ahead of a 2035 deadline partly because accelerating Earth rotation created a 30% chance of a never-before-used negative leap second, which could disrupt time-critical software and infrastructure. Keeping UTC continuous may let software remove fragile leap-second handling; astronomers can continue using UT1 offsets. A remaining concern is WWV/WWVB radio time signals, whose DUT1 field assumes the offset stays under one second, potentially affecting astronomy and navigation if unresolved. The overview reflects the supplied article text, including its stated estimates and forecasts.

### Source excerpt

There will never be a leap second again. At least not for UTC. At the CGPM, they decided the last leap second we'll ever see for UTC, or Coordinated Universal Time, happened back at the end of 2016. Of course they made that decision while I was out on vacation, so I'm just getting this video up now: But what's the CGPM, why does this matter, and why am I excited about it?

## Canada's 2026 time zone updates: guidance for Microsoft SQL

DevFeed: [Canada's 2026 time zone updates: guidance for Microsoft SQL](<https://devfeed.tech/articles/canada-s-2026-time-zone-updates-guidance-for-microsoft-sql-87322.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/canadas-2026-time-zone-updates-guidance-for-microsoft-sql/>)

Author: Umachandar Jayachandran (UC)

Published: 2026-10-15T05:21:10Z

Content type: tutorial

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [sql-server](<https://devfeed.tech/topics/sql-server.md>), [timezone](<https://devfeed.tech/topics/timezone.md>), [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>)

Tags: [2026](<https://devfeed.tech/tags/2026.md>), [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [azure-sql-managed-instance](<https://devfeed.tech/tags/azure-sql-managed-instance.md>), [canada](<https://devfeed.tech/tags/canada.md>), [fabric-sql](<https://devfeed.tech/tags/fabric-sql.md>), [fabric-sql-database](<https://devfeed.tech/tags/fabric-sql-database.md>), [managed-instance](<https://devfeed.tech/tags/managed-instance.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [t-sql](<https://devfeed.tech/tags/t-sql.md>), [time](<https://devfeed.tech/tags/time.md>)

### AI overview

Microsoft outlines interim time zone guidance for SQL Server on Windows and Linux, Azure SQL Database, and Azure SQL Managed Instance ahead of Canada's November 2026 changes. It explains regional offsets, temporary identifiers and workarounds, configuration scope, and migration considerations when final regional zones are unavailable.

### Source excerpt

Affected locations in British Columbia, Alberta, and Manitoba will not turn their clocks back at 02:00 local time on November 1, 2026. They will remain at UTC−07:00, UTC−06:00, and UTC−05:00, respectively. Microsoft's interim guidance for British Columbia, Alberta, and Manitoba describes the new Windows time zones and temporary workarounds. SQL Server on Windows requires the [...] The post Canada's 2026 time zone updates: guidance for Microsoft SQL appeared first on Azure SQL Dev Corner.

## Git date parsing and identity handling show limits in a legal-document archive

DevFeed: [Git date parsing and identity handling show limits in a legal-document archive](<https://devfeed.tech/articles/git-will-stop-working-in-2100-64957.md>)

Original publisher: [Read original article](<https://hackernoon.com/git-will-stop-working-in-2100?source=rss>)

Author: Maximiliano Morel

Published: 2026-10-05T15:16:25Z

Content type: article

Language: en

Sources: [HackerNoon](<https://devfeed.tech/sources/hackernoon.md>)

Topics: [Git](<https://devfeed.tech/topics/git.md>), [Pull Request](<https://devfeed.tech/topics/pull-request.md>), [ISO 8601](<https://devfeed.tech/topics/iso-8601.md>), [timezone](<https://devfeed.tech/topics/timezone.md>), [parallel workspaces](<https://devfeed.tech/topics/parallel-workspaces.md>)

Tags: [computing](<https://devfeed.tech/tags/computing.md>), [dag](<https://devfeed.tech/tags/dag.md>), [developers](<https://devfeed.tech/tags/developers.md>), [future](<https://devfeed.tech/tags/future.md>), [git](<https://devfeed.tech/tags/git.md>), [git-2099-date-limit](<https://devfeed.tech/tags/git-2099-date-limit.md>), [git-commit-backdating](<https://devfeed.tech/tags/git-commit-backdating.md>), [git-commit-metadata](<https://devfeed.tech/tags/git-commit-metadata.md>), [git-date-parsing](<https://devfeed.tech/tags/git-date-parsing.md>), [git-legal-history](<https://devfeed.tech/tags/git-legal-history.md>), [git-limitations](<https://devfeed.tech/tags/git-limitations.md>), [git-y2k](<https://devfeed.tech/tags/git-y2k.md>), [legal](<https://devfeed.tech/tags/legal.md>), [version-control](<https://devfeed.tech/tags/version-control.md>)

### AI overview

After importing more than 330,000 Chilean legal documents into Git, the author describes problems with historical and future commit dates, inconsistent date and identity parsing, and misleading errors. Direct timestamps can pass beyond 2099, while ordinary date parsing rejects some ranges. The author compares Git with Mercurial and Fossil, and describes keeping historical metadata separately alongside the documents.

### Source excerpt

I put 330,000+ Chilean legal documents into Git and discovered strange limits around historical dates, future timestamps, identities, and parsers.

## Announcing the Public Preview of Local Time Zone Support in Azure SQL Database

DevFeed: [Announcing the Public Preview of Local Time Zone Support in Azure SQL Database](<https://devfeed.tech/articles/announcing-the-public-preview-of-local-time-zone-support-in-azure-sql-database-61031.md>)

Original publisher: [Read original article](<https://devblogs.microsoft.com/azure-sql/announcing-the-public-preview-of-local-time-zone-support-in-azure-sql-database/>)

Author: Umachandar Jayachandran (UC)

Published: 2026-09-28T15:00:17Z

Content type: release

Language: en

Sources: [Azure SQL Dev Corner](<https://devfeed.tech/sources/azure-sql-dev-corner.md>)

Topics: [Azure SQL](<https://devfeed.tech/topics/azure-sql.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [timezone](<https://devfeed.tech/topics/timezone.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [MySQL](<https://devfeed.tech/topics/mysql.md>), [Oracle Database](<https://devfeed.tech/topics/oracle-database.md>)

Tags: [azure-sql](<https://devfeed.tech/tags/azure-sql.md>), [azure-sql-database](<https://devfeed.tech/tags/azure-sql-database.md>), [database](<https://devfeed.tech/tags/database.md>), [sql](<https://devfeed.tech/tags/sql.md>), [t-sql](<https://devfeed.tech/tags/t-sql.md>), [time](<https://devfeed.tech/tags/time.md>)

### AI overview

Azure SQL Database now offers a public preview of configurable time zones at the database or session level using T-SQL. The database setting persists across connections and can be changed after creation; a session setting overrides it for one connection. Secondary replica databases inherit the primary replica's setting.

### Source excerpt

We are thrilled to announce the public preview of local time zone support in Azure SQL Database. Starting today, you can configure the time zone directly at the database or session level -- all from T-SQL, without changing any infrastructure settings. This feature addresses one of the most consistently requested capabilities from the Azure SQL [...] The post Announcing the Public Preview of Local Time Zone Support in Azure SQL Database appeared first on Azure SQL Dev Corner.

## Adventures in Daylight Saving, Norfolk Island, and Time Zone Math (in Ruby)

DevFeed: [Adventures in Daylight Saving, Norfolk Island, and Time Zone Math (in Ruby)](<https://devfeed.tech/articles/adventures-in-daylight-saving-norfolk-island-and-time-zone-math-in-ruby-20534.md>)

Original publisher: [Read original article](<https://code.dblock.org/2026/08/28/adventures-in-daylight-saving-norfolk-island-and-time-zone-math-in-ruby.html>)

Author: Daniel Doubrovkine (dblock@dblock.org)

Published: 2026-08-28T00:00:00Z

Content type: article

Language: en

Sources: [Daniel Doubrovkine](<https://devfeed.tech/sources/daniel-doubrovkine.md>)

Topics: [Ruby](<https://devfeed.tech/topics/ruby.md>), [timezone](<https://devfeed.tech/topics/timezone.md>)

Tags: [2015](<https://devfeed.tech/tags/2015.md>), [administrator](<https://devfeed.tech/tags/administrator.md>), [daylight](<https://devfeed.tech/tags/daylight.md>), [dst](<https://devfeed.tech/tags/dst.md>), [ireland](<https://devfeed.tech/tags/ireland.md>), [island](<https://devfeed.tech/tags/island.md>), [math](<https://devfeed.tech/tags/math.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [ruby](<https://devfeed.tech/tags/ruby.md>), [saving](<https://devfeed.tech/tags/saving.md>), [time](<https://devfeed.tech/tags/time.md>), [time-zones](<https://devfeed.tech/tags/time-zones.md>), [utc](<https://devfeed.tech/tags/utc.md>)

### AI overview

The excerpt shows that duration calculations in the Ruby gem distance_of_time_in_words can fail when time-zone offsets change. In Europe/Dublin, checking dst? could give different answers for the same instant depending on how a Time was constructed, zeroing out a real one-minute interval. PR #152 replaced DST checks with comparisons of actual UTC offsets. That exposed another flaw: assuming every offset change is one hour. Norfolk Island's permanent shift from UTC+11:30 to UTC+11:00 produced incorrect duration output. The excerpt introduces PR #154 as the next fix but cuts off before explaining it. It says the first two fixes shipped in versions 5.6.0 and 5.6.1, followed by four more shortly after.

### Source excerpt

distance_of_time_in_words is a small Ruby gem that turns two Time objects into a human-readable string like "3 days and 4 hours". Several separate bug reports against it turned out to be variations on the same theme: computing a duration between two timestamps is not the trivial subtraction it looks like, the moment time zones are involved. The first two fixes shipped in dotiw 5.6.0; four more followed shortly after in dotiw 5.6.1. Bug 1: dst? Lies When You Least Expect It #63 reported that a duration of one minute was rendered as "less than 1 second" for users in Europe/Dublin. The gem's TimeHash had a DST correction that looked reasonable: d = largest - smallest d -= 1.hour if smallest.dst? && !largest.dst? d += 1.hour if !smallest.dst? && largest.dst? The idea: if a DST transition happened between the two times, Time subtraction already accounts for the wall-clock jump, so cancel it back out before splitting the duration into calendar units. That works everywhere except Ireland. Europe/Dublin uses an inverted DST scheme: its winter time is legally defined as "standard time minus one hour" rather than the more common "standard time is winter, summer is +1". Depending on whether a Time was constructed via Time.at(seconds) or datetime.to_time, dst? could report different values for the exact same instant, even though utc_offset agreed. The correction fired when it shouldn't have, and a real one-minute gap got silently zeroed out. Reproducing it doesn't even require mocking dst? -- just running the example with the right TZ set is enough: ENV['TZ'] = 'Europe/Dublin' start = Time.at(DateTime.now) finish = DateTime.now + 1.minute # => "less than 1 second" # expected: "1 minute" distance_of_time_in_words(start, finish) The fix (PR #152) was to stop asking "is this DST?" and just compare the actual offsets: def offset_decreased?(smallest, largest) smallest.utc_offset > largest.utc_offset end def offset_increased?(smallest, largest) smallest.utc_offset < largest.utc_offset

## 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?](<https://devfeed.tech/articles/how-to-render-timestamp-with-a-timezone-that-is-different-from-current-33675.md>)

Original publisher: [Read original article](<https://www.depesz.com/2026/01/27/how-to-render-timestamp-with-a-timezone-that-is-different-from-current/>)

Author: depesz

Published: 2026-01-27T09:25:04Z

Content type: tutorial

Language: en

Sources: [select \* from depesz;](<https://devfeed.tech/sources/select-from-depesz.md>)

Topics: [timezone](<https://devfeed.tech/topics/timezone.md>), [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [DateTime](<https://devfeed.tech/topics/datetime.md>)

Tags: [formatting](<https://devfeed.tech/tags/formatting.md>), [how-to](<https://devfeed.tech/tags/how-to.md>), [irc](<https://devfeed.tech/tags/irc.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [timestamptz](<https://devfeed.tech/tags/timestamptz.md>), [timezone](<https://devfeed.tech/tags/timezone.md>), [to-char](<https://devfeed.tech/tags/to-char.md>), [uncategorized](<https://devfeed.tech/tags/uncategorized.md>), [utc](<https://devfeed.tech/tags/utc.md>)

### 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?"

## Set variables in Traffic Policy for cleaner, reusable configs

DevFeed: [Set variables in Traffic Policy for cleaner, reusable configs](<https://devfeed.tech/articles/set-variables-in-traffic-policy-for-cleaner-reusable-configs-83330.md>)

Original publisher: [Read original article](<https://ngrok.com/blog/set-variables-traffic-policy>)

Author: Joel Hans

Published: 2025-05-05T00:00:00Z

Content type: release

Language: en

Sources: [\[ngrok news\]](<https://devfeed.tech/sources/ngrok-news.md>)

Topics: [timezone](<https://devfeed.tech/topics/timezone.md>), [Environment Variables](<https://devfeed.tech/topics/environment-variables.md>), [Plover](<https://devfeed.tech/topics/plover.md>)

Tags: [ai](<https://devfeed.tech/tags/ai.md>), [api](<https://devfeed.tech/tags/api.md>), [authentication](<https://devfeed.tech/tags/authentication.md>), [configs](<https://devfeed.tech/tags/configs.md>), [product-updates](<https://devfeed.tech/tags/product-updates.md>), [traffic-management](<https://devfeed.tech/tags/traffic-management.md>), [traffic-policy](<https://devfeed.tech/tags/traffic-policy.md>), [variables](<https://devfeed.tech/tags/variables.md>)

### AI overview

The article introduces the `set-vars` Traffic Policy action, which lets users define and reuse variables in request and response handling. Variables can simplify configurations, support expressions and interpolations, and help manage reusable lists for authentication and traffic filtering.

### Source excerpt

Define lists, maps, and interpolated values inside your traffic management rules--then reference them anywhere--to make configs both simpler and more dynamic.

## One timezone for everything: k8tz and the Jakarta timestamp problem

DevFeed: [One timezone for everything: k8tz and the Jakarta timestamp problem](<https://devfeed.tech/articles/one-timezone-for-everything-k8tz-and-the-jakarta-timestamp-problem-34030.md>)

Original publisher: [Read original article](<https://andikaahmad.com/blog/k8tz-timezone-injection/>)

Published: 2024-11-20T00:00:00Z

Content type: article

Language: en

Sources: [Andika Ahmad Ramadhan](<https://devfeed.tech/sources/andika-ahmad-ramadhan-blog.md>)

Topics: [Kubernetes](<https://devfeed.tech/topics/kubernetes.md>), [timezone](<https://devfeed.tech/topics/timezone.md>), [certificates](<https://devfeed.tech/topics/certificates.md>), [TLS (Transport Layer Security)](<https://devfeed.tech/topics/tls.md>), [elasticsearch](<https://devfeed.tech/topics/elasticsearch.md>)

Tags: [certificates](<https://devfeed.tech/tags/certificates.md>), [elasticsearch](<https://devfeed.tech/tags/elasticsearch.md>), [kubernetes-admission-controller](<https://devfeed.tech/tags/kubernetes-admission-controller.md>), [timezone](<https://devfeed.tech/tags/timezone.md>), [tls](<https://devfeed.tech/tags/tls.md>)

### 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.

## Format dashboard timestamps and time zones

DevFeed: [Format dashboard timestamps and time zones](<https://devfeed.tech/articles/format-dashboard-timestamps-and-time-zones-83229.md>)

Original publisher: [Read original article](<https://ngrok.com/blog/format-timestamps-time-zones>)

Author: Russ Savage

Published: 2024-07-24T00:00:00Z

Content type: release

Language: en

Sources: [\[ngrok news\]](<https://devfeed.tech/sources/ngrok-news.md>)

Topics: [timezone](<https://devfeed.tech/topics/timezone.md>), [superProductivity](<https://devfeed.tech/topics/superproductivity.md>)

Tags: [dashboard](<https://devfeed.tech/tags/dashboard.md>), [debugging](<https://devfeed.tech/tags/debugging.md>), [event](<https://devfeed.tech/tags/event.md>), [http](<https://devfeed.tech/tags/http.md>), [ngrok](<https://devfeed.tech/tags/ngrok.md>), [observability](<https://devfeed.tech/tags/observability.md>), [product-updates](<https://devfeed.tech/tags/product-updates.md>)

### AI overview

ngrok adds account settings for choosing the timezone and date and time format used for dashboard timestamps, including local time, UTC, or a custom format. The release also adds timestamps to the ngrok agent console to help distinguish repeat requests to the same endpoint.

### Source excerpt

Customize timestamps in your ngrok dashboard to streamline debugging and enhance event observability across time zones.

## Building On-call: Time, timezones, and scheduling

DevFeed: [Building On-call: Time, timezones, and scheduling](<https://devfeed.tech/articles/building-on-call-time-timezones-and-scheduling-12044.md>)

Original publisher: [Read original article](<https://incident.io/blog/time-time-zones-and-scheduling>)

Author: Henry Course

Published: 2024-07-18T15:40:00Z

Content type: article

Language: en

Sources: [The incident.io Blog](<https://devfeed.tech/sources/the-incident-io-blog.md>)

Topics: [timezone](<https://devfeed.tech/topics/timezone.md>), [Test-driven development](<https://devfeed.tech/topics/tdd.md>), [Database](<https://devfeed.tech/topics/database.md>), [CI/CD](<https://devfeed.tech/topics/cicd.md>)

Tags: [complexity](<https://devfeed.tech/tags/complexity.md>), [consider](<https://devfeed.tech/tags/consider.md>), [incident](<https://devfeed.tech/tags/incident.md>), [incident-channel](<https://devfeed.tech/tags/incident-channel.md>), [incident-management](<https://devfeed.tech/tags/incident-management.md>), [incident-response](<https://devfeed.tech/tags/incident-response.md>), [on-call](<https://devfeed.tech/tags/on-call.md>), [outage](<https://devfeed.tech/tags/outage.md>), [post-mortem](<https://devfeed.tech/tags/post-mortem.md>), [scheduler](<https://devfeed.tech/tags/scheduler.md>), [scheduling](<https://devfeed.tech/tags/scheduling.md>), [slack-incident](<https://devfeed.tech/tags/slack-incident.md>), [testing](<https://devfeed.tech/tags/testing.md>), [time](<https://devfeed.tech/tags/time.md>)

### AI overview

The scheduler models rota activity and handovers across working hours, round-robin shifts, overrides, and irregular transitions. To manage timezone and daylight-saving complexity, the system stores and processes UTC instants where possible, using Postgres `timestamptz` for consistent conversions and confining local-time conversions to defined, tested points. Schedule times were first shown in the schedule's timezone, but customer feedback led to timezone selectors and other UI cues for users who need local or simultaneous views; natural-language entry via Sherlock also helps fill override times. Testing combines unit tests for time-based building blocks, manually checked JSON snapshots diffed on each build, and a scheduled audit comparing evaluated schedules with cached on-call values. The audit can catch incorrect timing but not bugs in the shared evaluation logic.

### Source excerpt

Time is tricky, but building our On-call scheduler meant getting cozy with all of its quirks-- and lots of testing. No "time" like the present to dive in!

## How do I find out my timezone in Linux?

DevFeed: [How do I find out my timezone in Linux?](<https://devfeed.tech/articles/how-do-i-find-out-my-timezone-in-linux-41914.md>)

Original publisher: [Read original article](<https://www.cyberciti.biz/faq/find-checking-timezone-in-linux-using-command-line/>)

Author: Vivek Gite

Published: 2024-04-06T01:06:44Z

Content type: tutorial

Language: en

Sources: [nixCraft](<https://devfeed.tech/sources/nixcraft-linux-tips-hacks-tutorials-and-ideas-in-blog-format-rss-feed.md>)

Topics: [Linux](<https://devfeed.tech/topics/linux.md>), [timezone](<https://devfeed.tech/topics/timezone.md>), [Command-line interface](<https://devfeed.tech/topics/cli.md>), [systemd](<https://devfeed.tech/topics/systemd.md>), [Unix](<https://devfeed.tech/topics/unix.md>), [DateTime](<https://devfeed.tech/topics/datetime.md>)

Tags: [command-line](<https://devfeed.tech/tags/command-line.md>), [easy](<https://devfeed.tech/tags/easy.md>), [environment-variables](<https://devfeed.tech/tags/environment-variables.md>), [grep-command](<https://devfeed.tech/tags/grep-command.md>), [linux](<https://devfeed.tech/tags/linux.md>), [systemd](<https://devfeed.tech/tags/systemd.md>), [timedatectl](<https://devfeed.tech/tags/timedatectl.md>), [timezone](<https://devfeed.tech/tags/timezone.md>), [unix](<https://devfeed.tech/tags/unix.md>)

### 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.

## Avoiding Hydration Mismatches with useSyncExternalStore

DevFeed: [Avoiding Hydration Mismatches with useSyncExternalStore](<https://devfeed.tech/articles/avoiding-hydration-mismatches-with-usesyncexternalstore-48176.md>)

Original publisher: [Read original article](<https://tkdodo.eu/blog/avoiding-hydration-mismatches-with-use-sync-external-store>)

Published: 2024-02-21T00:00:00Z

Content type: article

Language: en

Sources: [TkDodo](<https://devfeed.tech/sources/tkdodo-s-blog.md>)

Topics: [React](<https://devfeed.tech/topics/react.md>), [browser](<https://devfeed.tech/topics/browser.md>), [client](<https://devfeed.tech/topics/client.md>), [Server](<https://devfeed.tech/topics/server.md>), [timezone](<https://devfeed.tech/topics/timezone.md>), [User Experience](<https://devfeed.tech/topics/user-experience.md>), [render](<https://devfeed.tech/topics/render.md>), [markup](<https://devfeed.tech/topics/markup.md>)

Tags: [browser](<https://devfeed.tech/tags/browser.md>), [client](<https://devfeed.tech/tags/client.md>), [code](<https://devfeed.tech/tags/code.md>), [markup](<https://devfeed.tech/tags/markup.md>), [react](<https://devfeed.tech/tags/react.md>), [render](<https://devfeed.tech/tags/render.md>), [server](<https://devfeed.tech/tags/server.md>), [timezone](<https://devfeed.tech/tags/timezone.md>), [user-experience](<https://devfeed.tech/tags/user-experience.md>)

### AI overview

A React-focused article explains why server-rendered and client-rendered output can differ during hydration, especially when locale, timezone, or browser-only APIs are involved. It discusses suppressing warnings, rendering twice, and using effects to avoid hydration errors, along with the tradeoff of a brief flash of content.

### Source excerpt

Avoiding hydration mismatches can usually be done in two ways - suppressing the warning or spawning an effect. But is there a third option ... ?

## Choosing timestamp data types across five databases

DevFeed: [Choosing timestamp data types across five databases](<https://devfeed.tech/articles/timestamps-are-hard-82521.md>)

Original publisher: [Read original article](<https://omni.co/blog/database-timestamps>)

Author: Jack Sweeney

Published: 2023-10-30T16:00:00Z

Content type: tutorial

Language: en

Sources: [Omni Blog](<https://devfeed.tech/sources/omni-blog.md>)

Topics: [timezone](<https://devfeed.tech/topics/timezone.md>)

Tags: [bigquery](<https://devfeed.tech/tags/bigquery.md>), [databases](<https://devfeed.tech/tags/databases.md>), [timestamps](<https://devfeed.tech/tags/timestamps.md>)

### AI overview

The article investigates a Snowflake timestamp join failure involving daylight saving time, then compares timestamp types in Snowflake, BigQuery, Redshift, Postgres, and MySQL. It recommends types that store timestamps in UTC and display them in the session time zone, and discusses database changes and BI-layer workarounds.

### Source excerpt

Most people care about daylight saving time once or twice a year. Recently, I had the pleasure of thinking about it for a third time with a stronger-than-usual frustration.

## Local timezones available on profiles

DevFeed: [Local timezones available on profiles](<https://devfeed.tech/articles/local-timezones-available-on-profiles-73873.md>)

Original publisher: [Read original article](<https://github.blog/changelog/2022-09-23-local-timezones-available-on-profiles>)

Author: Kevin Duck

Published: 2022-09-23T15:59:21Z

Content type: release

Language: en

Sources: [GitHub Changelog](<https://devfeed.tech/sources/github-changelog.md>)

Topics: [timezone](<https://devfeed.tech/topics/timezone.md>)

Tags: [display](<https://devfeed.tech/tags/display.md>), [feature](<https://devfeed.tech/tags/feature.md>), [local](<https://devfeed.tech/tags/local.md>), [profile](<https://devfeed.tech/tags/profile.md>), [public](<https://devfeed.tech/tags/public.md>), [settings](<https://devfeed.tech/tags/settings.md>), [timezone](<https://devfeed.tech/tags/timezone.md>), [utc](<https://devfeed.tech/tags/utc.md>)

### AI overview

You can display your local timezone on your profile to help others anticipate when you may respond to pull requests or issues. Enable it in Settings > Public Profile by checking `Display current local time`, or use "Edit Profile" under your avatar. Your profile's sidebar and user hovercard show your timezone and its current offset from UTC; other users also see how many hours ahead or behind they are relative to your local time.

### Source excerpt

You can now display your local timezone on your profile to give others an idea of when to expect responses to pull requests or issues from you. You can opt...

## PostgreSQL

DevFeed: [PostgreSQL](<https://devfeed.tech/articles/postgresql-34117.md>)

Original publisher: [Read original article](<https://artandscienceofcoding.com/devrecipes/database/postgresql/>)

Author: Derek Lee

Published: 2022-03-01T00:00:00Z

Content type: tutorial

Language: en

Sources: [art and science of coding](<https://devfeed.tech/sources/art-and-science-of-coding.md>)

Topics: [PostgreSQL](<https://devfeed.tech/topics/postgresql.md>), [Database](<https://devfeed.tech/topics/database.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [configuration](<https://devfeed.tech/topics/configuration.md>), [timezone](<https://devfeed.tech/topics/timezone.md>), [JSON](<https://devfeed.tech/topics/json.md>)

Tags: [configuration](<https://devfeed.tech/tags/configuration.md>), [database](<https://devfeed.tech/tags/database.md>), [dev-recipes](<https://devfeed.tech/tags/dev-recipes.md>), [installation](<https://devfeed.tech/tags/installation.md>), [json](<https://devfeed.tech/tags/json.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [psql](<https://devfeed.tech/tags/psql.md>), [setup](<https://devfeed.tech/tags/setup.md>), [sql](<https://devfeed.tech/tags/sql.md>), [timezone](<https://devfeed.tech/tags/timezone.md>), [troubleshooting](<https://devfeed.tech/tags/troubleshooting.md>)

### 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

## GIS in Go

DevFeed: [GIS in Go](<https://devfeed.tech/articles/gis-in-go-22178.md>)

Original publisher: [Read original article](<https://www.ardanlabs.com/blog/2021/11/gis-in-go.html>)

Published: 2021-11-01T00:00:00Z

Content type: article

Language: en

Sources: [William Kennedy](<https://devfeed.tech/sources/william-kennedy.md>)

Topics: [CSV](<https://devfeed.tech/topics/csv.md>), [groupby](<https://devfeed.tech/topics/groupby.md>), [timezone](<https://devfeed.tech/topics/timezone.md>), [Data pipelines](<https://devfeed.tech/topics/data-pipelines.md>), [plotting](<https://devfeed.tech/topics/plotting.md>)

Tags: [ardan-labs](<https://devfeed.tech/tags/ardan-labs.md>), [blog](<https://devfeed.tech/tags/blog.md>), [csv](<https://devfeed.tech/tags/csv.md>), [data](<https://devfeed.tech/tags/data.md>), [gis](<https://devfeed.tech/tags/gis.md>), [go](<https://devfeed.tech/tags/go.md>), [go-programming](<https://devfeed.tech/tags/go-programming.md>), [golang](<https://devfeed.tech/tags/golang.md>), [programming](<https://devfeed.tech/tags/programming.md>)

### AI overview

The article outlines a Go workflow for turning a 740-row jogging track CSV into a map: parse timestamp, latitude, longitude, and height fields; convert UTC times to a supplied time zone; group rows by a time interval and average each field to reduce points; then generate HTML using Leaflet. The excerpt describes CSV loading through an io.Reader for flexibility and testing, and uses time.Parse with a custom time unmarshaler. It does not include the complete resampling implementation or the map-generation details.

### Source excerpt

Introduction You are jogging and want to show off your route to your friends. Let's imagine the data you have for your route is a CSV file in the following format: Listing 1: track.csv time,lat,lng,height 2015-08-20 03:48:07.235,32.519585,35.015021,136.1999969482422 2015-08-20 03:48:24.734,32.519606,35.014954,126.5999984741211 2015-08-20 03:48:25.660,32.519612,35.014871,123.0 2015-08-20 03:48:26.819,32.519654,35.014824,120.5 2015-08-20 03:48:27.828,32.519689,35.014776,118.9000015258789 2015-08-20 03:48:29.720,32.519691,35.014704,119.9000015258789 2015-08-20 03:48:30.669,32.519734,35.014657,120.9000015258789 Listing 1 shows the first few lines of track.csv. Each line contains a time stamp in UTC, latitude, longitude and height above sea level in meters.

## Dependabot now schedules version updates uniformly

DevFeed: [Dependabot now schedules version updates uniformly](<https://devfeed.tech/articles/dependabot-now-schedules-version-updates-uniformly-74428.md>)

Original publisher: [Read original article](<https://github.blog/changelog/2021-06-16-dependabot-now-schedules-version-updates-uniformly>)

Author: phanatic

Published: 2021-06-16T19:32:09Z

Content type: release

Language: en

Sources: [GitHub Changelog](<https://devfeed.tech/sources/github-changelog.md>)

Topics: [Dependabot](<https://devfeed.tech/topics/dependabot.md>), [timezone](<https://devfeed.tech/topics/timezone.md>)

Tags: [backend](<https://devfeed.tech/tags/backend.md>), [config](<https://devfeed.tech/tags/config.md>), [daily](<https://devfeed.tech/tags/daily.md>), [dependabot](<https://devfeed.tech/tags/dependabot.md>), [frontend](<https://devfeed.tech/tags/frontend.md>), [monthly](<https://devfeed.tech/tags/monthly.md>), [npm](<https://devfeed.tech/tags/npm.md>), [package-json](<https://devfeed.tech/tags/package-json.md>), [properties](<https://devfeed.tech/tags/properties.md>), [random](<https://devfeed.tech/tags/random.md>), [repository](<https://devfeed.tech/tags/repository.md>), [schedule](<https://devfeed.tech/tags/schedule.md>), [schedules](<https://devfeed.tech/tags/schedules.md>), [time](<https://devfeed.tech/tags/time.md>), [timezone](<https://devfeed.tech/tags/timezone.md>), [update](<https://devfeed.tech/tags/update.md>), [updates](<https://devfeed.tech/tags/updates.md>), [utc](<https://devfeed.tech/tags/utc.md>), [version](<https://devfeed.tech/tags/version.md>), [weekly](<https://devfeed.tech/tags/weekly.md>)

### AI overview

Dependabot no longer starts version updates without a specified time at 5 AM UTC for every repository. It assigns each repository a random start time, with all updates in that repository starting then, to reduce usage spikes that slow updates. To choose a start time, configure `schedule.time` and `schedule.timezone` for each update; the excerpt shows separate UTC and Pacific schedules for two npm directories.

### Source excerpt

Unless a specific time is provided, Dependabot version updates run at 5AM UTC daily, weekly, or monthly; however, this results in large usage spikes that slow down updates for everyone....

## Year in review 2020

DevFeed: [Year in review 2020](<https://devfeed.tech/articles/year-in-review-2020-28694.md>)

Original publisher: [Read original article](<https://jeroenmols.com/blog/2021/01/05/yearinreview/>)

Author: info@jeroenmols.com (Jeroen Mols)

Published: 2021-01-05T00:00:00Z

Content type: opinion

Language: en

Sources: [Jeroen Mols](<https://devfeed.tech/sources/jeroen-mols.md>)

Topics: [Code](<https://devfeed.tech/topics/code.md>), [timezone](<https://devfeed.tech/topics/timezone.md>)

Tags: [blogs](<https://devfeed.tech/tags/blogs.md>), [code](<https://devfeed.tech/tags/code.md>), [events](<https://devfeed.tech/tags/events.md>), [mastodon](<https://devfeed.tech/tags/mastodon.md>), [remote-work](<https://devfeed.tech/tags/remote-work.md>), [review](<https://devfeed.tech/tags/review.md>), [twitter](<https://devfeed.tech/tags/twitter.md>), [year-in-review](<https://devfeed.tech/tags/year-in-review.md>)

### 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](<https://devfeed.tech/articles/handling-dates-times-in-sqlite-30600.md>)

Original publisher: [Read original article](<https://ryanharter.com/blog/2020/09/handling-dates-times-in-sqlite/>)

Published: 2020-09-04T16:35:01Z

Content type: tutorial

Language: en

Sources: [Blogs on Ryan Harter](<https://devfeed.tech/sources/blogs-on-ryan-harter.md>)

Topics: [SQLite](<https://devfeed.tech/topics/sqlite.md>), [Database](<https://devfeed.tech/topics/database.md>), [DateTime](<https://devfeed.tech/topics/datetime.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [timezone](<https://devfeed.tech/topics/timezone.md>), [Kotlin](<https://devfeed.tech/topics/kotlin.md>)

Tags: [database](<https://devfeed.tech/tags/database.md>), [kotlin](<https://devfeed.tech/tags/kotlin.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [time](<https://devfeed.tech/tags/time.md>), [timezone](<https://devfeed.tech/tags/timezone.md>)

### 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.

## Timezone-aware contribution graphs

DevFeed: [Timezone-aware contribution graphs](<https://devfeed.tech/articles/timezone-aware-contribution-graphs-70027.md>)

Original publisher: [Read original article](<https://github.blog/news-insights/the-library/timezone-aware-contribution-graphs/>)

Author: Dirkjan Bussink

Published: 2014-03-08T00:28:34Z

Content type: release

Language: en

Sources: [GitHub Blog](<https://devfeed.tech/sources/github-engineering.md>)

Topics: [timezone](<https://devfeed.tech/topics/timezone.md>), [GitHub](<https://devfeed.tech/topics/github.md>)

Tags: [developers](<https://devfeed.tech/tags/developers.md>), [features](<https://devfeed.tech/tags/features.md>), [github](<https://devfeed.tech/tags/github.md>), [news-insights](<https://devfeed.tech/tags/news-insights.md>), [the-library](<https://devfeed.tech/tags/the-library.md>), [timezone](<https://devfeed.tech/tags/timezone.md>)

### AI overview

GitHub made contribution graphs timezone-aware. Commits are counted using the timezone in their timestamps, while pull requests and issues opened on the web use the browser's timezone; API users can specify a timezone. The change applies only to contributions after March 10, 2014, to preserve existing streaks.

### Source excerpt

Today we've made your contribution graphs timezone-aware. GitHub is used everywhere and we want to reflect that in our features. If you happen to work from Japan, Australia or Ulan...

[Next page](<https://devfeed.tech/topics/timezone.md?cursor=WyIyMDE0LTAzLTA4VDAwOjI4OjM0KzAwOjAwIiwgImViODIyMzgyLTVkYjQtNDU4Yi1hMjQzLTcwNzdkY2VmYmJhNyJd>)