How could I convert from GMT to british summer

I am looking to convert times that are in GMT to british summer,

How would i do this?
Thanks
LVL 2
meteorelecAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
BrandonGalderisiConnect With a Mentor Commented:
Assuming your server is set to that time, you can calculate time local to the server using this method.


dateadd(n, datediff(n, getutcdate(),getdate()), YourDateField

The problem with this approach is that if your SQL server is in a different time zone than your front end displaying it, the date will be local to the SQL server.
0
 
BrandonGalderisiCommented:
forgot closing )


select dateadd(n, datediff(n, getutcdate(),getdate()), YourDateField) from YourTable
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.