CODE EXAMPLE FOR SQL

sql datetime format dd/mm/yyyy hh:mm am/pm

select FORMAT(@date,'MM/dd/yyyy hh:mm:s tt')