asp classic - Dealing with timezones in vbscript

Question

I'm trying to change some old .asp files with vbs. Our database is going to be converted to store dates in UTC, but on webpages it should show dates and time in "Europe/Helsinki" timezone(

TimeZoneInfo.FindSystemTimeZoneById("FLE Standard Time")

in c#). How can I cast the UTC date I get from db query( the query is run in the .asp file as well and the result put into table) to correct date time using vbscript?

Answer 1

Just offset the UTC dates using DateAdd().

Const EETOffset = -2 'EET offset from UTC is -2 hours
Dim dbDateValue  'Assumed value from DB
Dim newDate
'... DB process to populate dbDateValue
newDate = DateAdd("h", EETOffset, dbDateValue)

^{Note: One problem with this approach is you will also have to compensate for EET and EEST (Eastern European Summer Time) manually based on the time of year. Which is also more difficult when you take into consideration some places don't use it and use EET all year round instead.
See EET – Eastern European Time (Standard Time).}

Depending on the RDMS you are using you should even be able to manipulate the dates before they get to the page as part of the initial query.

---

Useful Links

• Format current date and time
• How to format a datetime with minimal separators and timezone in VBScript?