Currently browsing tag



sprintf Format List

Returns a string formatted by the usual printf conventions of the C library function sprintf. See below for more details and see sprintf(3) or printf(3) on your system for an explanation of the general principles. For example: # Format number with up to 8 leading zeroes $result = sprintf(“%08d”, $number); …

SQL 2012 FORMAT for Date formatting

SQL 2012 FORMAT for Date formatting In SQL Server 2008 and earlier version used the CONVERT() function to handle the date formatting. As we notice that the function is not very user friendly. In SQL Server 2012, a new function named FORMAT() has been introduced which is much easier to …