What is the format of date returned from database if you use your account?

yyyy-mm-dd hh:mm:ss:ms

e.g. 2008-03-04 10:44:54.000

How do you convert it to requested format?

cast(convert(varchar, createddate, 103) as datetime)

returns: 2008-03-04 00:00:00.000

Have also tried: dateadd(dd, 0, datediff(dd, 0, createddate)) which returns same date as cast/convert.