How to display current date as given format in SQL SERVER ?

Dec 28 2016 8:29 AM
 How to display current date in given format.
 
Display current date as   Dec/28/12  in SQL Server.
 
 
 Thanks,
Purushottam  
 

Answers (7)