Skip to main content

system.kanoa.date.getTimeZoneOffsetMins

Description

Given a timezone and a timestamp, this function will return the timezone offset minutes from the database time i.e. 'Pacific Standard Time', system.date.now() might return -480 Database can be queried to get a list of valid timezones with SELECT * FROM sys.time_zone_info or use the system.kanoa.date.getTimezones() function.

Syntax

getTimeZoneOffsetMins(timezone, tStamp)
  • Parameters:
      timezone (string): i.e. 'Pacific Standard Time'
      tStamp (datetime)
  • Returns:
      timeZoneOffsetMins (int)

    • Code Example​

    # Example Usage:
    timezones = system.kanoa.date.getTimeZoneOffsetMins('Pacific Standard Time', system.date.now())