Skip to content

How-to

Fix common date and time problems

Each page takes one problem people run into with dates, timestamps and time zones, explains why it happens, and fixes it with a worked example you can open in the converter. Most also show the fix in Excel, Google Sheets or code.

For the background on a format or a concept — what ISO 8601 allows, how Unix time works, why daylight saving breaks software — read the guides.

New to UTC, time zones or Unix timestamps? Start with the basics.

Spreadsheets and CSV files

Excel and Sheets rewriting dates, day/month swaps, serial numbers and import formats.

Timestamps in code, logs and databases

Unix units, log lines and database values turned into readable dates in your zone.

Time zones and daylight saving

Clock changes and zone abbreviations that leave a time one hour off.

A problem that is not here?

The converter reads 82 date and time formats: paste a value and it says which format it read and in which zone.

Open the converter