急,帮忙

[cenlmmx]

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

[lxzm1001]

select substring(convert(varchar,getdate(),120),12,5)

[WangZWang]

select Left(Convert(varchar(10),BeginTime,108),5) as BeginTime from dayaction

[paoluo]

Select Convert(Varchar(5),GetDate(),114)
--Result
/*
08:30
*/

[paoluo]

Select Convert(Varchar(5),BeginTime,114) as BeginTime from dayaction

[paoluo]

最簡單的寫法

[paoluo]

Or

Select Convert(Varchar(5),BeginTime,108) as BeginTime from dayaction

[cenlmmx]

非常感谢大家,结贴