593
社区成员
发帖
与我相关
我的任务
分享
LEN(@[用户::v_str])-(LEN(REPLACE(@[用户::v_str],".",""))/LEN("."))
DATEPART("weekday",GETDATE()) == 7 || DATEPART("weekday",GETDATE()) == 1 ? "休息" : "工作"
(DT_WSTR,4)YEAR(GETDATE()) + "-" + RIGHT("00"+(DT_WSTR,2)MONTH(GETDATE()),2)
+ "-" + RIGHT("00"+(DT_WSTR,2)DAY(GETDATE()),2)
+ " " + RIGHT("00"+(DT_WSTR,2)DATEPART("hour",GETDATE()),2)
+ ":" + RIGHT("00"+(DT_WSTR,2)DATEPART("minute",GETDATE()),2)
+ ":" + RIGHT("00"+(DT_WSTR,2)DATEPART("second",GETDATE()),2)
RIGHT("00"+(DT_WSTR,2)MONTH(GETDATE()),2)
+ "/" + RIGHT("00"+(DT_WSTR,2)DAY(GETDATE()),2)
+ "/" + (DT_WSTR,4)YEAR(GETDATE())