A
Jun 17, 2026Adjusting Postgres Databases for British Columbia's Time Zone Changes: Ensuring Accurate Timestamps
Introduction British Columbia’s recent time zone changes have introduced a subtle yet...
Jun 17, 202612 min read0 reactions0 comments
Back to articles 
Aug 31, 2020
Tag archive
#timestamp
T
Apr 20, 2026The latest() Bug That Silently Duplicated Transaction IDs in Production
TL;DR: Using Model::latest()->first() to get the "latest" record by ID is wrong. latest() orders...
Apr 20, 20263 min read1 reactions0 comments
W
Jan 10, 2026What's an EPOCH and Why It Still Matters More Than You Think?
Time is something we deal with constantly in software, but very few people stop to think about how...
Jan 10, 20262 min read0 reactions0 comments
Unix Time Stamp Converter
Convert Unix Timestamps I would like to introduce you to my free & online Unix timesta...
Aug 31, 20201 min read4 reactions2 comments
S
Jan 6, 2020SQL: Timestamps
The TIMESTAMP data type holds values that contain both date and time, fixed at 19 characters. The for...
Jan 6, 20202 min read41 reactions4 comments
M
Mar 29, 2018MYSQL Query With Timestamp Long Values
In unusual circumstances you be faced with a situation where you have long value representation of date-time at hand but you need to query over a timestamp field in MYSQL. Here is a small utility function that converts the long value to a MYSQL TIMESTAMP comparable format. The output from it can easily be passed to the TIMESTAMP function.
Mar 29, 20181 min read9 reactions0 comments