「MariaDB 10.6.4」UNIXタイムスタンプから日付に変換する
環境
windows 10 64bit
MariaDB 10.6.4
書式
FROM_UNIXTIME(値)
「FROM_UNIXTIME()」を使用して、unixtimeから日時に変換します。
使用例
SQL構文
SELECT FROM_UNIXTIME(1651098782) resA,FROM_UNIXTIME(1651098370) resB;
実行結果
MariaDB [(none)]> SELECT FROM_UNIXTIME(1651098782) resA,FROM_UNIXTIME(1651098370) resB;
+---------------------+---------------------+
| resA | resB |
+---------------------+---------------------+
| 2022-04-28 07:33:02 | 2022-04-28 07:26:10 |
+---------------------+---------------------+
1 row in set (0.000 sec)
MariaDB [(none)]> SELECT FROM_UNIXTIME(1651098782) resA,FROM_UNIXTIME(1651098370) resB;
+---------------------+---------------------+
| resA | resB |
+---------------------+---------------------+
| 2022-04-28 07:33:02 | 2022-04-28 07:26:10 |
+---------------------+---------------------+
1 row in set (0.000 sec)
MariaDB [(none)]> SELECT FROM_UNIXTIME(1651098782) resA,FROM_UNIXTIME(1651098370) resB; +---------------------+---------------------+ | resA | resB | +---------------------+---------------------+ | 2022-04-28 07:33:02 | 2022-04-28 07:26:10 | +---------------------+---------------------+ 1 row in set (0.000 sec)