Hi, I have a datatype of DateTime.
I want to parse out parts of the value to build my custom string, e.g.
cast(datepart(dd, BeginTime) as char(2)) + '/' + cast(datepart(mm, BeginTime) as char(2))
Problem is I only seem to be able to get the month in a 1 number format, I want august to be 08 and not just 8. Thought this would be very easy but I am stuck.