Format Function comes with SQL Server 2012. This function is similar to Dot Net String Format function.
Syntax:
FORMAT(column_name,string_format)
Example:
Select Format(Getdate(),'MMM-dd-yyyy')
Result:
Jun-05-2015
Format Function comes with SQL Server 2012. This function is similar to Dot Net String Format function.
Syntax:
FORMAT(column_name,string_format)
Example:
Select Format(Getdate(),'MMM-dd-yyyy')
Result:
Jun-05-2015
In more detail @ http://bit.ly/1kcxUt5