FORMAT

The new FORMAT function in SQL Server 2012 returns a formatted value based on a specified format and optional culture argument. The FORMAT function is primarily intended to be used for locale-aware formatting of date/time and number values as strings. For general data type conversions, you should continue to use CAST or CONVERT.

The syntax of the new FORMAT function is as follows:

Click here to view code image

FORMAT ( value, format [, culture ] )

The format argument must contain a valid .NET Framework format string, either as a standard format string (for example, "C" or "D") or as a pattern of custom characters for dates and numeric values (for example, "MMMM DD, yyyy (dddd)"). Table 44.2 lists the standard number format strings and ...

Get Microsoft® SQL Server 2012 Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial