SQL Database Timestamp Reference

Distinct Relational Database Management Systems run custom internal functions to pull or evaluate integer timestamps. This dictionary maps execution commands across common production database runtime tools.

1. MySQL / MariaDB Relational Engines

Generate Immediate Timestamp:

SELECT UNIX_TIMESTAMP();
-- Output representation: 1716584400

Parse Integer Parameter into Readable Local String:

SELECT FROM_UNIXTIME(1716584400);
-- Output string condition: '2026-05-24 15:30:00'

2. PostgreSQL Advanced Storage Nodes

Extract Integer Epoch Value:

SELECT EXTRACT(EPOCH FROM NOW())::INT;

Parse Timestamp Back into Standard System Zone Object:

SELECT TO_TIMESTAMP(1716584400);

3. SQLite Embedded Database Architecture

Fetch Live System Integer Metric:

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

Format Universal Integer to Readable Target Record:

SELECT datetime(1716584400, 'unixepoch');