title: Convert datetime field in sql server 2005
body: <p>I have a datetime field which has a value like this <code>5/11/2010 12:04:20 PM</code> .... I am converting this field <code>convert(varchar, dbo.Clients.CreatedDate,103) as CreatedDate</code> and i get  the result as <code>11/5/2010</code>..... But how to get <code>11/5/2010 12:04 PM</code>..... </p>