Unix Timestamp Converter: Convert to Date Online — Complete Guide

Convert Unix timestamps to dates and back. Complete guide for JavaScript, Python, Go, and databases.

What is a Unix Timestamp?

Unix time = seconds elapsed since 1970-01-01 00:00:00 UTC (the Unix epoch). Current value is ~1.7 billion seconds. JavaScript uses milliseconds (13 digits), while most systems use seconds (10 digits).

Get Current Timestamp

// JavaScript (milliseconds)
Date.now()                           // 1706745600000
Math.floor(Date.now() / 1000)        // 1706745600 (seconds)

# Python
import time
time.time()       # 1706745600.123 (float)
int(time.time())  # 1706745600

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

# Bash
date +%s  # 1706745600

Convert Timestamp to Date

// JavaScript
new Date(1706745600 * 1000).toISOString()     // "2024-02-01T00:00:00.000Z"
new Date(1706745600 * 1000).toLocaleString()  // local timezone

# Python
from datetime import datetime, timezone
datetime.fromtimestamp(1706745600)            # local time
datetime.utcfromtimestamp(1706745600)         # UTC (deprecated)
datetime.fromtimestamp(1706745600, tz=timezone.utc)  # UTC (preferred)

// Go
t := time.Unix(1706745600, 0)
fmt.Println(t.Format(time.RFC3339))  // "2024-02-01T00:00:00Z"

Convert Date to Timestamp

new Date('2024-02-01').getTime() / 1000     // 1706745600
Date.UTC(2024, 1, 1) / 1000                 // 1706745600 (UTC)

from datetime import datetime, timezone
datetime(2024, 2, 1, tzinfo=timezone.utc).timestamp()  # 1706745600.0

Milliseconds vs Seconds

Digits	Type	Example
10	Seconds	1706745600
13	Milliseconds	1706745600000

// Auto-detect
function normalizeTimestamp(ts) {
  return ts > 1e10 ? Math.floor(ts / 1000) : ts;
}

Database Timestamps

-- MySQL
SELECT UNIX_TIMESTAMP();                    -- current timestamp
SELECT FROM_UNIXTIME(1706745600);          -- to datetime

-- PostgreSQL
SELECT EXTRACT(EPOCH FROM NOW());           -- current timestamp
SELECT TO_TIMESTAMP(1706745600);           -- to timestamp

-- SQLite
SELECT strftime('%s', 'now');              -- current timestamp

Y2K38 Problem

32-bit signed integers overflow at 2147483647 (2038-01-19 03:14:07 UTC). Modern languages (Python, Go, 64-bit C) and PostgreSQL are already safe. Fix MySQL/MariaDB: use BIGINT instead of INT for timestamp columns.

Quick Tool

Use DevToolBox Unix Timestamp Converter — instantly convert between Unix timestamps and human-readable dates.

---

Convert Unix timestamps instantly with DevToolBox's free Timestamp Converter.