O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required