EASILY found on google. You could put this code into a Sql function if you want to:
CONVERT(char(10), MyDateTime, 101) AS [Date],
CONVERT(varchar(2),
CASE
WHEN DATEPART([hour], MyDateTime) > 12 THEN CONVERT(varchar(2), (DATEPART([hour], MyDateTime) - 12))
WHEN DATEPART([hour], MyDateTime) = 0 THEN '12'
ELSE CONVERT(varchar(2), DATEPART([hour], MyDateTime))
END
) + ':' +
CONVERT(char(2), SUBSTRING(CONVERT(char(5), MyDateTime, 108), 4, 2)) + ' ' +
CONVERT(varchar(2),
CASE
WHEN DATEPART([hour], MyDateTime) > 12 THEN 'PM'
ELSE 'AM'
END
)