Problem with datepart function. 1

[bsimbeck]

When using use the datepart function to return a the minutes of a time if the time is 9:06 then I only get 6 when I do datepart(mi, act_dt). Does anyone know how I can get it to produce the leading zero?

Note: act_dt is the field name of the field that contains the datetime. I have tried casting it as int, a varchar, and a decimal none have worked.

Thanks in Advance!

Branden

 

[JamesLean]

SELECT RIGHT('0' + CAST(DATEPART(mi, act_dt) AS varchar), 2)
FROM tbl

--James