vbscript time zones and Daylight Savings

Question

I'm looking for an easy way to get UTC times and date/time information in vbscript, even while specifying a time zone. I need to be able to get the current time in a time zone of my choice.

I have seen postings on the web for functions that determine DST, but I'd rather not use something I'd have to update if DST or time zones switched--so using a standard library would be ideal. I don't have the option of using a web service with this application. I'm open to other ideas, though.

Answer 1

If you have access to a database you could use a database query to determine time zones.

• For MSSQL, see this way of doing it
• For TSQL, see this stack overflow question

Answer 2

The code here may help:

http://classicasp.aspfaq.com/date-time-routines-manipulation/how-do-i-convert-local-time-to-utc-gmt-time.html