finereport
娃哈哈哇
新人小白
展开
-
strftime时间文本处理函数和多if和多条件使用
SELECT * FROM 订单 where 1=1 ${if(type=="日报"," and date(订购日期)='"+ date +"'", if(type=="月报"," and strftime('%m',订单.订购日期)='"+ month+"'"+" and strftime('%Y',订单.订购日期)='"+ year+"'"," and strftime('%Y',订单.订原创 2018-01-30 09:42:52 · 680 阅读 · 3 评论 -
查office时间
cscript "C:\Program Files\Microsoft Office\Office16\ospp.vbs" /dstatus原创 2018-06-08 10:35:26 · 547 阅读 · 0 评论