Media Summary: Should you store dates & times in your database as A web app that works out how many seconds ago something happened. How hard can coding that be? Tom Scott explains how ... This video explains the time system used on earth as well as the concepts of solar time, local time, time zones

Utc Vs Timezone The Bug - Detailed Analysis & Overview

Should you store dates & times in your database as A web app that works out how many seconds ago something happened. How hard can coding that be? Tom Scott explains how ... This video explains the time system used on earth as well as the concepts of solar time, local time, time zones Talk given at the meetup. Unfortunately my mic didn't work Two of the most common date expressions we will ever type are "SYSDATE" Your scheduled job dies at 1 AM — no error, no log. It's not your code. It's how time itself works: cron reads the machine's clock, ...

At 1:30 in the morning, a cron job ran. Fifty-nine minutes later, it ran AGAIN — same job, same 1:30. Nobody scheduled it twice.

Photo Gallery

UTC vs Timezone - The Bug That Costs Developers Hours
JavaScript Date Object and Time Zones | Fixing an "off by 1 day" bug
How to Fix Timezone & Daylight Savings Bugs in SQL Databases (UTC Migration Guide)
Just store UTC? Handling Time Zones & Daylight Saving
The Problem with Time & Timezones - Computerphile
Time Zones and the Coordinated Universal Time
Time Zones and DST for Coders
Look Up Timezones, UTC Offsets & DST for Any US, Canada, Mexico or UK Address Using Geocodio
UTC Time Zone Explained and Unix Epoch Timestamp
The UTC timezone. Why SYSDATE might be wrong for you
Why Your Automation Fails at 1 AM [2026] (Cron, Timezones)
06 - Store UTC, Render Local — the One Time-Zone Rule Every Dev Should Know
View Detailed Profile
UTC vs Timezone - The Bug That Costs Developers Hours

UTC vs Timezone - The Bug That Costs Developers Hours

Time zone bugs

JavaScript Date Object and Time Zones | Fixing an "off by 1 day" bug

JavaScript Date Object and Time Zones | Fixing an "off by 1 day" bug

How to handle

How to Fix Timezone & Daylight Savings Bugs in SQL Databases (UTC Migration Guide)

How to Fix Timezone & Daylight Savings Bugs in SQL Databases (UTC Migration Guide)

Learn essential database design

Just store UTC? Handling Time Zones & Daylight Saving

Just store UTC? Handling Time Zones & Daylight Saving

Should you store dates & times in your database as

The Problem with Time & Timezones - Computerphile

The Problem with Time & Timezones - Computerphile

A web app that works out how many seconds ago something happened. How hard can coding that be? Tom Scott explains how ...

Time Zones and the Coordinated Universal Time

Time Zones and the Coordinated Universal Time

This video explains the time system used on earth as well as the concepts of solar time, local time, time zones

Time Zones and DST for Coders

Time Zones and DST for Coders

Talk given at the http://porto.codes meetup. Unfortunately my mic didn't work

Look Up Timezones, UTC Offsets & DST for Any US, Canada, Mexico or UK Address Using Geocodio

Look Up Timezones, UTC Offsets & DST for Any US, Canada, Mexico or UK Address Using Geocodio

Look up

UTC Time Zone Explained and Unix Epoch Timestamp

UTC Time Zone Explained and Unix Epoch Timestamp

The Unix

The UTC timezone. Why SYSDATE might be wrong for you

The UTC timezone. Why SYSDATE might be wrong for you

Two of the most common date expressions we will ever type are "SYSDATE"

Why Your Automation Fails at 1 AM [2026] (Cron, Timezones)

Why Your Automation Fails at 1 AM [2026] (Cron, Timezones)

Your scheduled job dies at 1 AM — no error, no log. It's not your code. It's how time itself works: cron reads the machine's clock, ...

06 - Store UTC, Render Local — the One Time-Zone Rule Every Dev Should Know

06 - Store UTC, Render Local — the One Time-Zone Rule Every Dev Should Know

At 1:30 in the morning, a cron job ran. Fifty-nine minutes later, it ran AGAIN — same job, same 1:30. Nobody scheduled it twice.

What Is UTC Time? (Meteorology)

What Is UTC Time? (Meteorology)

UTC