成人在线亚洲_国产日韩视频一区二区三区_久久久国产精品_99国内精品久久久久久久

您的位置：首頁技術(shù)文章
文章詳情頁

sqlite時間戳轉(zhuǎn)時間語句(時間轉(zhuǎn)時間戳)

瀏覽：272日期：2023-04-05 14:56:07

下面是具體的實現(xiàn)代碼：

sqlite> SELECT datetime(1377168853, "unixepoch", "localtime");

+------------------------------------------------+
| datetime(1377168853, "unixepoch", "localtime") |
+------------------------------------------------+
| 2013-08-22 18:54:13      |
+------------------------------------------------+
1 row in set

sqlite> SELECT strftime("%s","now");
+----------------------+
| strftime("%s","now") |
+----------------------+
| 1380728519      |
+----------------------+
1 row in set

sqlite> SELECT datetime("now");
+---------------------+
| datetime("now")   |
+---------------------+
| 2013-10-02 15:40:44 |
+---------------------+
1 row in set
標(biāo)簽： SQLite
相關(guān)文章：