Advanced Search

Return to Snippet

Revision: 41065
at February 11, 2011 09:59 by davidrodriguez
Initial Code 
SELECT DATEADD(hour,DATEDIFF(hour,GETUTCDATE(),GETDATE()),[Column]) AS "Column" FROM [Table]
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
How to convert a column of DATETIME UTC to local time.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
DATETIME Convert UTC to Local

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL