• It's as easy as this:

    SELECT format(getdate(), 'MM/dd/yyyy HH:mm:ss')

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]