Display time for other timezones

• FRANKNF

  SSC Veteran

  Points: 285

  More actions

  March 16, 2003 at 6:07 pm

  #64581

  I need to generate reports for multiple locations, adjusting the time as held on the server to apply for remote timezones(inc daylight saving adjustments).

  I know what the offset for each location is to GMT but Daylight saving adjustments are beyond me at the moment

  Is there any easy way to access Windows time for other locations via sql .

  Or any other suggestions?

  I am using SQL 7.

  Franknf

  
  Franknf

• Antares686

  SSC Guru

  Points: 125444

  More actions

  March 17, 2003 at 3:24 am

  #451196

  Please do not cross post. See/leave replies in thread http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=10636&FORUM_ID=8&CAT_ID=1&Topic_Title=Showing+Date%2FTimes+adjusted+for++remote+locations&Forum_Title=T%2DSQL