Basics
What is Epoch Time? Unix Timestamp Origins Explained
Ever wondered why modern server computers trace time parameters back to January 1, 1970? Uncover the architectural origins and technical benefits behind Unix time counting systems.
Jan 2025 · 4 min read
System
The Year 2038 Problem: Legacy Time Systems Warning
A look into the upcoming modern integer overflow challenge threating standard signed 32-bit hardware systems globally. Learn how engineering ecosystems transition toward 64-bit durability.
Jan 2025 · 5 min read
Python
Python DateTime Cheat Sheet for Unix Timestamps
Copy-paste references for working with epochs using datetime, time, and the arrow library in Python.
Jan 2025 · 5 min read
SQL
Unix Timestamps in SQL: MySQL, PostgreSQL & SQLite
How to store, convert, and query epoch timestamps across the three most popular relational databases.
Jan 2025 · 6 min read
PHP
Unix Timestamps in PHP: time(), strtotime(), and DateTime
Everything PHP developers need for working with epoch time, formatting dates, and handling timezones.
Feb 2025 · 5 min read
Java / Kotlin
Unix Timestamps in Java and Kotlin
Using Instant, System.currentTimeMillis(), and modern java.time APIs to work with epoch timestamps.
Feb 2025 · 5 min read
Deep Dive
Negative Unix Timestamps: Dates Before 1970 Explained
What negative epoch values mean, which languages and databases handle them correctly, and common pitfalls.
Mar 2025 · 4 min read
Excel
How to Convert Unix Timestamp in Excel
A simple formula to turn any 10-digit epoch number into a human-readable date inside Microsoft Excel or Google Sheets.
Mar 2025 · 3 min read
JavaScript
Unix Timestamps in JavaScript and TypeScript
Using Date.now(), new Date(), toISOString(), and epoch conversion patterns in JS and TypeScript.
Apr 2025 · 4 min read
Go
Unix Timestamps in Go (Golang)
How to use time.Now().Unix(), time.Unix(), and time.Time for epoch handling and formatting in Go.
Apr 2025 · 4 min read
Rust
Unix Timestamps in Rust
Working with SystemTime, UNIX_EPOCH, and the chrono crate for timestamp handling in Rust.
May 2025 · 4 min read
Databases
Timestamps in Databases: MySQL, PostgreSQL, MongoDB, Redis
How each database stores and queries Unix timestamps — with practical query examples for all four.
May 2025 · 6 min read
API Design
Unix Timestamps in API Design: Epoch vs ISO 8601
Why REST and GraphQL APIs use epoch integers, the tradeoffs vs ISO strings, and best practices.
May 2025 · 4 min read
Debugging
Debugging Common Timestamp Bugs
Fix seconds vs milliseconds confusion, off-by-one-hour timezone errors, and DST edge cases.
Jun 2025 · 5 min read
Ruby
Unix Timestamps in Ruby and Rails
Using Time.now.to_i, Time.at(), and ActiveSupport timezone helpers for epoch work in Ruby on Rails.
Jun 2025 · 4 min read