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

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

Comments are closed.