Name Date
Unix Timestamp worksheet
Grades 5–6 · CCSS 5.MD.A.1
Calcapedia Solve each problem and show your work. Round answers to 2 decimal places where needed.
- 1.
Problem 1. - Convert: Date to timestamp
- Date (UTC): Feb 6, 2026
- Time (UTC, 24-hour): 16:49
- Seconds: 0
- Also show in time zone: UTC only
Find: Unix timestamp (seconds)
Answer
- 2.
Problem 2. - Convert: Timestamp to date
- Unix timestamp: 2,200,000,000 seconds
- Also show in time zone: Moscow
Find: Date and time (UTC)
Answer
- 3.
Problem 3. - Convert: Timestamp to date
- Unix timestamp: 1,400,000,000 seconds
- Also show in time zone: Los Angeles (US Pacific)
Find: Date and time (UTC)
Answer
- 4.
Problem 4. - Convert: Timestamp to date
- Unix timestamp: 1,650,000,000 seconds
- Also show in time zone: São Paulo
Find: Date and time (UTC)
Answer
- 5.
Problem 5. - Convert: Timestamp to date
- Unix timestamp: 1,600,000,000 seconds
- Also show in time zone: Moscow
Find: Date and time (UTC)
Answer
- 6.
Problem 6. - Convert: Date to timestamp
- Date (UTC): May 14, 2025
- Time (UTC, 24-hour): 14:13
- Seconds: 0
- Also show in time zone: India (Kolkata)
Find: Unix timestamp (seconds)
Answer
- 7.
Problem 7. - Convert: Date to timestamp
- Date (UTC): Jun 20, 2025
- Time (UTC, 24-hour): 14:34
- Seconds: 1
- Also show in time zone: Auckland
Find: Unix timestamp (seconds)
Answer
- 8.
Problem 8. - Convert: Timestamp to date
- Unix timestamp: 1,750,000,000 seconds
- Also show in time zone: Chicago (US Central)
Find: Date and time (UTC)
Answer
- 9.
Problem 9. - Convert: Timestamp to date
- Unix timestamp: 2,000,000,000 seconds
- Also show in time zone: UTC only
Find: Date and time (UTC)
Answer
- 10.
Problem 10. - Convert: Date to timestamp
- Date (UTC): Aug 10, 2025
- Time (UTC, 24-hour): 13:46
- Seconds: 0
- Also show in time zone: São Paulo
Find: Unix timestamp (seconds)
Answer
Answer key: Unix Timestamp worksheet
Calcapedia 1. Unix timestamp (seconds): 1770396540
Count the days from January 1, 1970, the starting point of Unix time, to Feb 6, 2026 (negative for earlier dates)
Turn everything into seconds: each day is 86,400 seconds, each hour 3,600 and each minute 60. Then add them up
Write it without commas, the way computers store it
2. Date and time (UTC): Sun, Sep 18, 2039 23:06:40 UTC
Find the whole days since January 1, 1970: divide by the 86,400 seconds in a day and round down
The seconds left over tell you how far into that day it is, in UTC
Split those leftover seconds into hours (3,600 seconds each), minutes (60 seconds each) and seconds
Count 25,462 days forward from Thursday, January 1, 1970 to find the date
Put the date and time together
3. Date and time (UTC): Tue, May 13, 2014 16:53:20 UTC
Find the whole days since January 1, 1970: divide by the 86,400 seconds in a day and round down
The seconds left over tell you how far into that day it is, in UTC
Split those leftover seconds into hours (3,600 seconds each), minutes (60 seconds each) and seconds
Count 16,203 days forward from Thursday, January 1, 1970 to find the date
Put the date and time together
4. Date and time (UTC): Fri, Apr 15, 2022 05:20:00 UTC
Find the whole days since January 1, 1970: divide by the 86,400 seconds in a day and round down
The seconds left over tell you how far into that day it is, in UTC
Split those leftover seconds into hours (3,600 seconds each), minutes (60 seconds each) and seconds
Count 19,097 days forward from Thursday, January 1, 1970 to find the date
Put the date and time together
5. Date and time (UTC): Sun, Sep 13, 2020 12:26:40 UTC
Find the whole days since January 1, 1970: divide by the 86,400 seconds in a day and round down
The seconds left over tell you how far into that day it is, in UTC
Split those leftover seconds into hours (3,600 seconds each), minutes (60 seconds each) and seconds
Count 18,518 days forward from Thursday, January 1, 1970 to find the date
Put the date and time together
6. Unix timestamp (seconds): 1747231980
Count the days from January 1, 1970, the starting point of Unix time, to May 14, 2025 (negative for earlier dates)
Turn everything into seconds: each day is 86,400 seconds, each hour 3,600 and each minute 60. Then add them up
Write it without commas, the way computers store it
7. Unix timestamp (seconds): 1750430041
Count the days from January 1, 1970, the starting point of Unix time, to Jun 20, 2025 (negative for earlier dates)
Turn everything into seconds: each day is 86,400 seconds, each hour 3,600 and each minute 60. Then add them up
Write it without commas, the way computers store it
8. Date and time (UTC): Sun, Jun 15, 2025 15:06:40 UTC
Find the whole days since January 1, 1970: divide by the 86,400 seconds in a day and round down
The seconds left over tell you how far into that day it is, in UTC
Split those leftover seconds into hours (3,600 seconds each), minutes (60 seconds each) and seconds
Count 20,254 days forward from Thursday, January 1, 1970 to find the date
Put the date and time together
9. Date and time (UTC): Wed, May 18, 2033 03:33:20 UTC
Find the whole days since January 1, 1970: divide by the 86,400 seconds in a day and round down
The seconds left over tell you how far into that day it is, in UTC
Split those leftover seconds into hours (3,600 seconds each), minutes (60 seconds each) and seconds
Count 23,148 days forward from Thursday, January 1, 1970 to find the date
Put the date and time together
10. Unix timestamp (seconds): 1754833560
Count the days from January 1, 1970, the starting point of Unix time, to Aug 10, 2025 (negative for earlier dates)
Turn everything into seconds: each day is 86,400 seconds, each hour 3,600 and each minute 60. Then add them up
Write it without commas, the way computers store it