Converting GMT to EST

• rs80

  SSCrazy

  Points: 2312

  More actions

  September 3, 2013 at 11:03 am

  #279415

  I need to write a function that converts a time from GMT to EST taking daylight savings time into consideration.

  On a high level I was thinking of doing the following:

  a) a table that holds the daylight saving dates for this year and upcoming years. does anyone know a website that has these dates published?

  b) if the date passed to the function is greater or equal to the date for the fall daylight saving date (i.e., 11/2013) but less than the spring daylight saving date (i.e., 3/2014) then subtract 6 from the gmt to get est

  c) if the date passed to the function is greater or equal to the date for the fall daylight saving date (i.e., 3/2014) but less than the spring daylight saving date (i.e., 11/2014) then subtract 5 from the gmt to get est

• Michael Valentine Jones

  SSC Guru

  Points: 64818

  More actions

  September 3, 2013 at 11:54 am

  #1647118

  Eastern Daylight Time (EDT) is UTC (GMT) -4 hours

  Eastern Standard Time (EST) is UTC (GMT) -5 hours

  You should be able to find all the information you need here:

  Daylight Saving Time – DST

  http://www.timeanddate.com/time/dst/

• saravanakumar.G

  SSC Eights!

  Points: 817

  More actions

  September 3, 2013 at 11:18 pm

  #1647178

  Use GETUTCDATE() which is available in SQL Serevr , it will convert your timezone into GMT .