Handle Time Zones and Daylight Savings Time in SQL Server

I wanted to know how we can handle Time Zones and Daylight Savings Time in SQL Server 2000 as well as 2005.

Any pointers would be helpful.

Pranav

Pranav:

Get started by giving the getUTCDate() funciton a look. Other useful functions include dateadd, datediff, datename, datepart, day, getdate, month, year and day. Check out books online for more information about the functions.

Also, remember that in most cases the server platforms that MS SQL Server runs on automatically corrects for daylight savings time on the OS level so this is normally not something that you have to worry about.

Dave