2008-06-30
sql server 只取日期
CONVERT(datetime, CONVERT(varchar, GETDATE(), 103), 103)
CONVERT(datetime, CONVERT(varchar, GETDATE(), 103)
and ((isdiscontinue !=1) or (isdiscontinue =1 and DiscontinueDate>= CONVERT(datetime, CONVERT(varchar, GETDATE(), 101))))
select DATEDIFF(minute, convert(datetime,
'2008-01-01 ' + SUBSTRING('0830', 1, 2) + ':' +
SUBSTRING('0830', 3, 2),
120), convert(datetime,
'2008-01-01 ' + SUBSTRING('0831', 1, 2) + ':' +
SUBSTRING('0831', 3, 2),
120))
CONVERT(datetime, CONVERT(varchar, GETDATE(), 103)
and ((isdiscontinue !=1) or (isdiscontinue =1 and DiscontinueDate>= CONVERT(datetime, CONVERT(varchar, GETDATE(), 101))))
select DATEDIFF(minute, convert(datetime,
'2008-01-01 ' + SUBSTRING('0830', 1, 2) + ':' +
SUBSTRING('0830', 3, 2),
120), convert(datetime,
'2008-01-01 ' + SUBSTRING('0831', 1, 2) + ':' +
SUBSTRING('0831', 3, 2),
120))
评论排行榜