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 Examples​

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