What is Format Function in SQL Server?


Posted on June 5th, 2015 by Hitesh Kumar | 305 Views

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?

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

Comments are closed.