Pages

Sunday, September 15, 2013

SQL SERVER – Introduction and Example for DATEFORMAT Command | Journey to SQL Authority with Pinal Dave

While doing surprise code review of Jr. DBA I found interesting syntax DATEFORMAT. This keywords is very less used as CONVERT and CAST can do much more than this command. It is still interesting to learn about learn about this new syntax. Sets the order of the dateparts (month/day/year) for entering datetime or smalldatetime data.… Continue Reading...

Source: SQL SERVER – Introduction and Example for DATEFORMAT Command | Journey to SQL Authority with Pinal Dave