Convert to Datetime MM/dd/yyyy HH:mm:ss in Sql Server

Question

How to convert given date format to MM/dd/yyyy HH:mm:ss

I tried this one below but not achieved. Can anyone help me?

SELECT CONVERT(VARCHAR(20), GETDATE(), 120)

Answer 1

Supported by SQL Server 2005 and later versions

SELECT CONVERT(VARCHAR(10), GETDATE(), 101) 
       + ' ' + CONVERT(VARCHAR(8), GETDATE(), 108)

* See Microsoft's documentation to understand what the 101 and 108 style codes above mean.

Supported by SQL Server 2012 and later versions

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

Result

Both of the above methods will return:

10/16/2013 17:00:20

Answer 2

Try below:

SELECT CONVERT(VARCHAR(20), GETDATE(), 101)