■1Dateadd(wk,datediff...... 1Dateadd(wk,datediff(wk,0,getdate()),-1) 2Dateadd(wk,datediff(wk,0,getdate()),6) 3 4Dateadd(mm,datediff(mm,0,getdate()),0) 5Dateadd(ms,-3,dateadd(mm,datediff(m,0,getdate())+1,0)) 6 7Dateadd(yy,datediff(yy,0,getdate()),0) 8Dateadd(ms,-3,DATEADD(yy, DATEDIFF(yy,0,getdate())+1, 0)) |
|小黑屋|最新主题|手机版|微赢网络技术论坛 ( 苏ICP备08020429号 )
GMT+8, 2024-9-30 09:21 , Processed in 0.093915 second(s), 12 queries , Gzip On, MemCache On.
Powered by Discuz! X3.5
© 2001-2023 Discuz! Team.