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?

MS Sql Server LazyDBA home page