Unix时间戳转换工具

什么是Unix时间戳？

时间戳是自 1970 年 1 月 1 日（00:00:00 GMT）以来的秒数。它也被称为 Unix 时间戳（Unix Timestamp）。

Unix时间戳(Unix timestamp)，或称Unix时间(Unix time)、POSIX时间(POSIX time)，是一种时间表示方式，定义为从格林威治时间1970年01月01日00时00分00秒起至现在的总秒数。Unix时间戳不仅被使用在Unix系统、类Unix系统中，也在许多其他操作系统中被广泛采用。

如何在不同编程语言中获取当前Unix时间戳？

long timestamp = System.currentTimeMillis() / 1000;
// 或者
long timestamp = Instant.now().getEpochSecond();

import time
timestamp = int(time.time())

let timestamp = Math.floor(Date.now() / 1000);

$timestamp = time();

import "time"
timestamp := time.Now().Unix()

#include <time.h>
time_t timestamp = time(NULL);

#include <chrono>
auto timestamp = std::chrono::duration_cast<std::chrono::seconds>
    (std::chrono::system_clock::now().time_since_epoch()).count();

timestamp = Time.now.to_i

SELECT UNIX_TIMESTAMP();

SELECT DATEDIFF(second, '1970-01-01', GETUTCDATE())

date +%s

如何将Unix时间戳转换为普通时间？

long timestamp = 1726382400;
Date date = new Date(timestamp * 1000);
// 或者使用 LocalDateTime
LocalDateTime dateTime = LocalDateTime.ofEpochSecond(timestamp, 0, ZoneOffset.UTC);

import datetime
timestamp = 1726382400
dt = datetime.datetime.fromtimestamp(timestamp)

let timestamp = 1726382400;
let date = new Date(timestamp * 1000);

$timestamp = 1726382400;
$date = date('Y-m-d H:i:s', $timestamp);

import "time"
timestamp := int64(1726382400)
t := time.Unix(timestamp, 0)

#include <time.h>
time_t timestamp = 1726382400;
struct tm *timeinfo = localtime(×tamp);

SELECT FROM_UNIXTIME(1726382400);

date -d @1726382400

如何将普通时间转换为Unix时间戳？

LocalDateTime dateTime = LocalDateTime.of(2024, 9, 15, 12, 0, 0);
long timestamp = dateTime.toEpochSecond(ZoneOffset.UTC);

import datetime
dt = datetime.datetime(2024, 9, 15, 12, 0, 0)
timestamp = int(dt.timestamp())

let date = new Date('2024-09-15 12:00:00');
let timestamp = Math.floor(date.getTime() / 1000);

$timestamp = strtotime('2024-09-15 12:00:00');

import "time"
t, _ := time.Parse("2006-01-02 15:04:05", "2024-09-15 12:00:00")
timestamp := t.Unix()

#include <time.h>
struct tm timeinfo = {0};
timeinfo.tm_year = 2024 - 1900;
timeinfo.tm_mon = 9 - 1;
timeinfo.tm_mday = 15;
time_t timestamp = mktime(&timeinfo);

SELECT UNIX_TIMESTAMP('2024-09-15 12:00:00');

date -d '2024-09-15 12:00:00' +%s