UNIX_TIMESTAMP([date])

MySQL 8.4 🇮🇩 Bahasa Indonesia

Jika UNIX_TIMESTAMP() dipanggil tanpa argumen tanggal, ia mengembalikan stempel waktu Unix yang mewakili detik sejak '1970-01-01 00:00:00' UTC.

Syntax

MYSQL

SELECT UNIX_TIMESTAMP();
1447431666
SELECT UNIX_TIMESTAMP('2015-11-13 10:20:19');
1447431619
SELECT UNIX_TIMESTAMP('2015-11-13 10:20:19.012');
1447431619.012

Contoh

Example

If UNIX_TIMESTAMP() is called with a date argument, it returns the value of the argument as seconds since '1970-01-01 00:00:00' UTC. The server interprets date as a value in the session time zone and converts it to an internal Unix timestamp value in UTC. (Clients can set the session time zone as described in Section 7.1.15, “MySQL Server Time Zone Support”.) The date argument may be a DATE, DATETIME, or TIMESTAMP string, or a number in YYMMDD, YYMMDDhhmmss, YYYYMMDD, or YYYYMMDDhhmmss format. If the argument includes a time part, it may optionally include a fractional seconds part.

MYSQL

SELECT UNIX_TIMESTAMP();
1447431666
SELECT UNIX_TIMESTAMP('2015-11-13 10:20:19');
1447431619
SELECT UNIX_TIMESTAMP('2015-11-13 10:20:19.012');
1447431619.012

Example 2

The return value is an integer if no argument is given or the argument does not include a fractional seconds part, or DECIMAL if an argument is given that includes a fractional seconds part.

MYSQL

SET time_zone = 'MET';
SELECT UNIX_TIMESTAMP('2005-03-27 03:00:00');
+---------------------------------------+
| UNIX_TIMESTAMP('2005-03-27 03:00:00') |
+---------------------------------------+
|                            1111885200 |
+---------------------------------------+
SELECT UNIX_TIMESTAMP('2005-03-27 02:00:00');
+---------------------------------------+
| UNIX_TIMESTAMP('2005-03-27 02:00:00') |
+---------------------------------------+
|                            1111885200 |
+---------------------------------------+
SELECT FROM_UNIXTIME(1111885200);
+---------------------------+
| FROM_UNIXTIME(1111885200) |
+---------------------------+
| 2005-03-27 03:00:00       |
+---------------------------+