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

Related posts:

  1. Contact Us
  2. Send email using smtp server.
  3. What is Eomonth Function in SQL Server?
  4. What is DATEFROMPARTS Function in SQL Server?

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

Comments are closed.