covert Time"/>
covert Time
select CONVERT(Datetime, '1 '+ LEFT('Jul',3) + ' ' + RIGHT('10',2), 106)
2010-07-01 00:00:00.000
2010-07-01 13:00:00.000
CONVERT(varchar(5), xxxxxx, 108)
13:00
转载于:.html
更多推荐
covert Time
covert Time"/>
select CONVERT(Datetime, '1 '+ LEFT('Jul',3) + ' ' + RIGHT('10',2), 106)
2010-07-01 00:00:00.000
2010-07-01 13:00:00.000
CONVERT(varchar(5), xxxxxx, 108)
13:00
转载于:.html
更多推荐
covert Time
发布评论