Working with DateTime using Asp.Net & Sql Server

Here is some links working on date time using Asp.Net and Sql Server.
- Asp.Net
(1) How can I get total days of current Month., ASP.NET & Web Development, C#,VB.NET,XAML,.NET

(2) DateTime.ToString() Patterns

- Working with two dates
(1) SQL Server Solutions: Get Total Number of a Particular Day between Two Dates

(2) Working with weeks in C# - not that obvious

(3) How can I calculate the Number of Weekends between two dates - ASP.NET Forums

- Sql Server
(1) Date/Time Conversions Using SQL Server

(2) Microsoft SQL Server Tip: AM/PM Time format in SQL Server

(3) SQL Server Helper - Tips and Tricks - Date Formats