# UTC Published articles for UTC. This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles. ## 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?" ## I made Windows use UTC with Linux dual boot DevFeed: [I made Windows use UTC with Linux dual boot]() Original publisher: [Read original article]() Author: Tom Published: 2025-12-14T00:00:00Z Content type: tutorial Language: en Sources: [Tomasz Gągor]() Topics: [Linux](), [Windows](), [boot](), [Hardware]() Tags: [best-practices](), [debian](), [dual-boot](), [hardware](), [hardware-clock](), [linux](), [registry](), [time-synchronization](), [timedatectl](), [utc](), [windows]() ### AI overview A tutorial explains how to configure Windows and Linux to use UTC for the hardware clock in a dual-boot setup, helping avoid clock conflicts and time synchronization issues. ### Source excerpt Configure Windows to use UTC for the hardware clock when dual-booting with Linux, avoiding time synchronization issues and maintaining Linux defaults. ## Corrective Action Update for the Heroku June 10th Outage DevFeed: [Corrective Action Update for the Heroku June 10th Outage]() Original publisher: [Read original article]() Author: Michelle Peot Published: 2025-09-05T15:00:13Z Content type: article Language: en Sources: [Heroku]() Topics: [Heroku](), [incident](), [Resilience](), [Latency](), [Network]() Tags: [2025](), [heroku](), [incident](), [latency](), [news](), [outage](), [recovery](), [resilience](), [root-cause-analysis](), [utc]() ### AI overview Heroku provides a status update on corrective actions following the June 10, 2025 outage. The company attributes the disruption to an unintended vendor-applied system update, which also affected the Heroku Status site through design shortcomings and API latency. The update covers controls for immutable infrastructure, network resilience, independent communication channels, and faster investigation and recovery. ### Source excerpt Beginning at 06:00 UTC on Tuesday, Jun 10, 2025, Heroku customers began experiencing a platform service disruption due to an unintended system update applied to our production infrastructure by our vendor. To compound the issue, the Heroku Status site was affected by the outage. Shortcomings in site design and API latency resulted in timeouts, and the Status site appeared as if there were no active incidents. On June 15th we published a summary of our initial investigation, mitigation, and root cause analysis. We also identified the following post-incident remediation objectives: Ensuring immutable infrastructure Increasing resilience of communication channels Accelerating investigation and recovery As promised, we are providing a status update of our continued corrective actions. The post Corrective Action Update for the Heroku June 10th Outage appeared first on Heroku. ## Converting a UTC Date-Time String to a UNIX Epoch Timestamp in C and C++ DevFeed: [Converting a UTC Date-Time String to a UNIX Epoch Timestamp in C and C++]() Original publisher: [Read original article]() Published: 2025-01-19T15:02:00Z Content type: tutorial Language: en Sources: [Bert Hubert's writings]() Topics: [C](), [POSIX](), [C++]() Tags: [c](), [c-plus-plus](), [posix](), [programming](), [unix](), [utc]() ### AI overview The article examines how to convert a UTC date-time string into a UNIX epoch timestamp in C and C++. It discusses unexpected behavior in POSIX time-handling functions and the complications caused by local times and daylight-saving transitions. ### Source excerpt So how hard could it be. As input we have something like Fri, 17 Jan 2025 06:07:07 in UTC, and we'd like to turn this into 1737094027, the notional (but not actual) number of seconds that have passed since 1970-01-01 00:00:00 UTC. Trying to figure this out led me to discover many 'surprise features' and otherwise unexpected behaviour of POSIX time handling functions as implemented in various C libraries & the languages that build on them. ## Leap Seconds and GNSS Time Offsets DevFeed: [Leap Seconds and GNSS Time Offsets]() Original publisher: [Read original article]() Published: 2021-08-03T08:03:10Z Content type: article Language: en Sources: [Bert Hubert's writings]() Topics: [systems](), [navigation]() Tags: [gnss](), [timing](), [utc]() ### AI overview The article explains how GNSS systems handle leap seconds. GPS, Galileo, and BeiDou use continuous monotonic timescales and broadcast their offsets from UTC so receivers can derive UTC accurately. ### Source excerpt Leap seconds are controversial things. Since the Earth does not rotate at a steady rate, over time the Earth could get ahead or behind "atomic time". Whatever solution you propose for this, someone is going to be unhappy. I take no position on what the best thing to do is here, except that one day I would like to do the math on the "great leap second gyroscopes" that we could mount near the poles to steady the Earth's rotation, so we can stop talking about this.