Convert Time Zone:

Convert Time Zone:

I have 05/02/2007 10:00AM CST, how can I convert this to EST in SQL Server 2000 function?

SQL Server has no idea about timezones. If you know the date you have is CST and you need to convert it to EST, you need use the datefunctions to add an hour.

DATEADD(Hour, 1, Yourdate)

|||Ok. Thanks, what about other timezones in US?|||same thing.. you can add or subtract accordingly. +1 or -2 etc.