Built-in functions of Transact-SQL

Many a times, we end up spending lot of time doing something that made available to us just due to lack of awareness.

Today I spent 30 minutes to get date as string from datetime column in database. Doing this from code is quite a trivial task.

But here I want to bind a source to UI control. DATENAME function solved my problem just like that. It is built-in function of SQL.

Here are some more references for built-in functions from MSDN

Functions (Transact-SQL)

• Aggregate Functions (Transact-SQL)
• Configuration Functions (Transact-SQL)
• Cryptographic Functions (Transact-SQL)
• Cursor Functions (Transact-SQL)
• Date and Time Data Types and Functions (Transact-SQL)
• Mathematical Functions (Transact-SQL)
• Metadata Functions (Transact-SQL)
• Ranking Functions (Transact-SQL)
• Replication Functions (Transact-SQL)
• Rowset Functions (Transact-SQL)
• Security Functions (Transact-SQL)
• String Functions (Transact-SQL)
• System Functions (Transact-SQL)
• System Statistical Functions (Transact-SQL)
• Text and Image Functions (Transact-SQL)