CANONICAL Function

--// To get month name using ODBC canonical function.
SELECT {fn MONTHNAME('03/15/2011')}

--// To get month name using ODBC canonical function.
SELECT {fn DAYNAME('03/15/2011')}

--// To get Current Datetime using ODBC canonical function.
SELECT {fn NOW()}

--// To get year using ODBC canonical function.
SELECT {fn YEAR('15-jan-2011')}

--// To get Week number of given year using ODBC canonical function.
SELECT {fn WEEK('01/15/2011')}

--// To Concatenate string using ODBC canonical function.
SELECT {fn CONCAT('Nikhil','das')}

--// To get Quarter of the year
SELECT {fn QUARTER('01/15/2011')}

Reference :
http://msdn.microsoft.com/en-us/library/bb738626.aspx