Is this a one time exercise ?

Can you have a look up table which has the time difference defined
and use that table ?

John
www.ideo.com

-----Original Message-----
From: [Email Address Removed] [mailto:[Email Address Removed] January 31, 2003 10:13 AM
To: LazyDBA.com Discussion
Subject: A riddle...


All my dates are stored in gmt in the database...

I now need to convert all the dates to cst. How do I do this for say 20 years of data and also take in to account daylight savings time from the past years?


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page