Date format returned as mm/dd/yyyy hh:mm:ss AM/PM

Since you're on SQL 2012 the format function should work:

declare @date datetime = '2014-09-26 11:04:54'select FORMAT(@date,'MM/dd/yyyy hh:mm:s tt')

result: 09/26/2014 11:04:54 AM

In your case it would be:

Select FORMAT(EntryDate,'MM/dd/yyyy hh:mm:s tt')From DB1

DECLARE @Date_Value DATETIME = GETDATE();SELECT CONVERT(VARCHAR(10), @Date_Value, 101) + ' '        + LTRIM(RIGHT(CONVERT(CHAR(20), @Date_Value, 22), 11))RESULT: 09/26/2014 5:25:53 PM

Your Query

SELECT CONVERT(VARCHAR(10), EntryDate, 101) + ' '        + LTRIM(RIGHT(CONVERT(CHAR(20), EntryDate, 22), 11))From DB1

    > select convert(varchar(20),GETDATE(),1)+' '+convert(varchar(20),convert(time,getdate()),100)    > select convert(varchar(20),GETDATE(),103)+' '+convert(varchar(20),convert(time,getdate()),100)    > select convert(varchar(20),GETDATE(),103)+' '+convert(varchar(20),convert(time,getdate()),22)    > Result (1) :-  10/15/2018 11:22AM (mm/dd/yyyy hh:mm AM/PM)    > Result (2):-  15/10/2018 11:22AM (dd/mm/yyyy hh:mm AM/PM)    > Result (3):-  15/10/2018 11:22:35 AM (dd/mm/yyyy hh:mm:ss AM/PM)