TSQL - FORMAT

Part of my new SQL 2012 TSQL features series is a look at the new FORMAT function. 
This function can be used to format date/time and number values as strings.
Almost all SQL developers will come across wanting to use SQL to format their dates in a specific way or make numbers more presentable.
It has a very simple syntax and does pretty much exactly what you'd hope. 



See the documents online for more usage examples.

Comments

Popular posts from this blog

Enabling SNMP on an ASUS RT-N66U

Realtek HD Audio speakers and headphones with separate volume

Reformatting a php.ini file with Sublime Text 3 for use with Ansible