有个日期字段,如果用select convert(varchar,datepart(hh,BeginTime)) + ':' + convert(varchar,datepart(mi,BeginTime)) as BeginTime from dayaction 有这样的结果
BeginTime
-----------
8:30 --> 想变为08:30
10:9 --> 想变为10:09
BeginTime
-----------
8:30 --> 想变为08:30
10:9 --> 想变为10:09
Select Convert(Varchar(5),GetDate(),114)
--Result
/*
08:30
*/