Working with time zones in vbscript

Question

I am trying to modify old .asp files with vbs. Our database will be converted to store dates in UTC, but on web pages it should show dates and times in the time zone "Europe / Helsinki" (

TimeZoneInfo.FindSystemTimeZoneById("FLE Standard Time")

in C #). How can I specify the UTC date that I get from the db request (the request is executed in the .asp file, as well as the result placed in the table) to fix the date using vbscript?

Answer 1

Just adjust the UTC dates with 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)

^{.. , EET EEST ( ) . , , EET . . EET - ( ).}

RDMS , .

---

• datetime VBScript?