What is Format Function in SQL Server?


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

One thought on “What is Format Function in SQL Server?

Comments are closed.