datetime-nodes1.txt

来自「SQLite 2.8.6 源代码,用来在Linux/Unix/Windows上编」· 文本 代码 · 共 17 行

%d day of month
%e day of month no leading zero
%H hour on a 24-hour clock
%I hour on a 12-hour clock
%k same as %H with leading zero suppression
%l same as %I with leading zero suppression
%m month 01-12
%M minute 00-59
%p AM or PM
%s seconds since 1970
%S seconds
%w day of week 0-6
%Y year
%% '%'

sprintf("%04d-%02d-%02d", YEAR('now'), 1+MONTH('now'), DAY('now'));