sqlite 格式化时间戳 strftime

来源：https://stackoverflow.com/questions/33114055/how-to-convert-timestamp-to-string-in-sqlite

SELECT
  date raw,
  strftime('%d-%m-%Y', datetime(date/1000, 'unixepoch', 'localtime')) as_string
FROM my_table

• datetime 先把 int 格式转换为 datetime

• strftime 格式化时间

datetime 函数的参数

来源：https://www.sqlite.org/lang_datefunc.html

• Compute the current date. SELECT date();

• Compute the last day of the current month. SELECT date('now','start of month','+1 month','-1 day');

• Compute the date and time given a unix timestamp 1092941466. SELECT datetime(1092941466, 'unixepoch'); SELECT datetime(1092941466, 'auto'); -- Does not work for early 1970!

• Compute the date and time given a unix timestamp 1092941466, and compensate for your local timezone. SELECT datetime(1092941466, 'unixepoch', 'localtime');

• Compute the current unix timestamp. SELECT unixepoch(); SELECT strftime('%s');

• Compute the number of days since the signing of the US Declaration of Independence. SELECT julianday('now') - julianday('1776-07-04');

• Compute the number of seconds since a particular moment in 2004: SELECT unixepoch() - unixepoch('2004-01-01 02:34:56');

• Compute the date of the first Tuesday in October for the current year. SELECT date('now','start of year','+9 months','weekday 2');

• Compute the time since the unix epoch in seconds with millisecond precision: SELECT (julianday('now') - 2440587.5)*86400.0; SELECT unixepoch('now','subsec');

• Compute how old Abraham Lincoln would be if he were still alive today: SELECT timediff('now','1809-02-12');