MSSQL ~ get datetime

SubmitTime is field name

CONVERT(varchar, SubmitTime, 20) as qqqq

reference
http://msdn.microsoft.com/en-us/library/aa226054.aspx