BestHub
Sign in
Lin is Dream
Lin is Dream
May 26, 2025 · Fundamentals

Why Time Bugs Threaten Software: From Y2K to the 2038 Problem

This article explores how time is represented in computers, explains historic bugs like the Y2K and the upcoming 2038 issue, clarifies GMT/UTC, time zones and daylight saving, and compares 32‑bit and 64‑bit timestamps, Java long handling, and architectural differences that affect time calculations.

2038 problem32-bit vs 64-bitJava long
0 likes · 12 min read
Why Time Bugs Threaten Software: From Y2K to the 2038 Problem
Java Backend Technology
Java Backend Technology
Jun 3, 2021 · Databases

Why MySQL TIMESTAMP Is a Hidden Pitfall and How to Avoid It

This article explains MySQL's three time types, highlights the quirks and automatic defaults of TIMESTAMP—including the 2038 problem, high‑concurrency issues, and unexpected behavior in non‑strict mode—provides practical examples, and offers guidance on configuring server variables or switching to DATETIME for safer handling.

2038 problemMySQLSQL
0 likes · 11 min read
Why MySQL TIMESTAMP Is a Hidden Pitfall and How to Avoid It
FunTester
FunTester
Sep 20, 2020 · Databases

When VIP Expiration Hits 2038: The MySQL INT Overflow Bug

A hidden bug occurs when a user's VIP subscription is repeatedly extended, causing the stored expiration timestamp to exceed MySQL's signed INT maximum of 2147483647 (January 19, 2038), which prevents the date from being saved correctly.

2038 problemINT overflowMySQL
0 likes · 3 min read
When VIP Expiration Hits 2038: The MySQL INT Overflow Bug