• SELECT FORMAT(GETDATE(), 'MM/dd/yyyy HH:mm:ss')

    AS [try the FORMAT function available in SQL 2012 and above];

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato