文章詳情頁
sqlite時間戳轉時間語句(時間轉時間戳)
瀏覽：661日期：2023-04-05 14:56:07
下面是具體的實現代碼：
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 標簽：
SQLite
上一條：初識SQLITE3數據庫下一條：SQLite3中自增主鍵相關知識總結
相關文章：
排行榜
網公網安備