datetime-nodes1.txt

SQLite 2.8.6 源代码,用来在Linux/Unix/Windows上编译安装.它是一个小型的数据库,但是非常好用,速度也快,一般的数据库查询之类的操作据统计比MySQL,PostgreSQL

%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'));