ตัวแปลง Timestamp ของ Unix

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

new Date(1735689600 * 1000).toISOString();

new Date('2025-01-01T00:00:00Z').getTime();

time();                // seconds
intval(microtime(true) * 1000); // milliseconds

date('Y-m-d H:i:s', 1735689600);

strtotime('2025-01-01 00:00:00');

import time

int(time.time())        # seconds
int(time.time() * 1000) # milliseconds

import datetime

datetime.datetime.utcfromtimestamp(1735689600).isoformat()

import datetime

int(datetime.datetime(2025,1,1,0,0,0,tzinfo=datetime.timezone.utc).timestamp())

import "time"

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

import "time"

time.Unix(1735689600, 0).UTC().Format(time.RFC3339)

import "time"

ts := time.Date(2025,1,1,0,0,0,0,time.UTC).Unix()

use chrono::Utc;

let now = Utc::now();
let sec = now.timestamp();        // seconds i64
let ms  = now.timestamp_millis(); // milliseconds i128

use chrono::{DateTime, NaiveDateTime, Utc};

let dt: DateTime = NaiveDateTime::from_timestamp_opt(1735689600, 0)
    .unwrap()
    .and_utc();
let iso = dt.to_rfc3339();

use chrono::DateTime;

let ts = DateTime::parse_from_rfc3339("2025-01-01T00:00:00Z")
    .unwrap()
    .timestamp();

-- MySQL / MariaDB
SELECT UNIX_TIMESTAMP();

-- PostgreSQL
SELECT EXTRACT(EPOCH FROM NOW())::bigint;

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

-- MySQL / MariaDB
SELECT FROM_UNIXTIME(1735689600);

-- PostgreSQL
SELECT to_timestamp(1735689600) AT TIME ZONE 'UTC';

-- SQLite
SELECT datetime(1735689600, 'unixepoch');

-- MySQL / MariaDB
SELECT UNIX_TIMESTAMP('2025-01-01 00:00:00');

-- PostgreSQL
SELECT EXTRACT(EPOCH FROM TIMESTAMP '2025-01-01 00:00:00+00')::bigint;

-- SQLite
SELECT strftime('%s', '2025-01-01 00:00:00');