Unix Timestamp Converter

How to use the Unix timestamp converter

The top box shows the current Unix time, updating every second, with copy buttons for seconds and milliseconds. To read a timestamp, paste it into Timestamp to date. The tool guesses the unit from the number of digits; pick Seconds, Milliseconds, Microseconds or Nanoseconds if it guesses wrong. You get the date in your own time zone, UTC and Philippine time, plus ISO 8601, RFC 2822 and how long ago (or how far ahead) it is.

To go the other way, choose a date, a time and a time zone in Date to timestamp. The timestamp updates as you change any of them.

Worked example

The timestamp 1700000000 has 10 digits, so it is in seconds. It is 14 November 2023, 22:13:20 UTC. The Philippines is 8 hours ahead, so in Manila it was 15 November 2023, 06:13:20. In milliseconds the same moment is 1700000000000. Going back, entering 2023-11-15, 06:13:20 with the time zone Asia/Manila gives 1700000000 again.

Get the current timestamp in code

JavaScript

Math.floor(Date.now() / 1000)   // seconds
Date.now()                       // milliseconds

Python

import time
int(time.time())                 # seconds
time.time_ns() // 1_000_000      # milliseconds

PHP

time();                          // seconds
(int) round(microtime(true) * 1000);  // milliseconds

Java

Instant.now().getEpochSecond()   // seconds
System.currentTimeMillis()       // milliseconds

Go

time.Now().Unix()                // seconds
time.Now().UnixMilli()           // milliseconds

SQL

-- MySQL / MariaDB
SELECT UNIX_TIMESTAMP();
-- PostgreSQL
SELECT EXTRACT(EPOCH FROM now())::bigint;
-- SQLite
SELECT strftime('%s', 'now');
-- SQL Server
SELECT DATEDIFF_BIG(SECOND, '1970-01-01', SYSUTCDATETIME());

Frequently asked questions