I have a handful of tables on my DB one in particular that is originally set based on eastern time. It has 12k+ records, and I am trying to find a sane approach to coverting the datatime records on these tables to match a gmt datetime equivalent without having to build a loop that will cycle over all the rows one by one updating them. Is that possible to do efficiently or am I going to have to loop over them one by one?