Contents x
      HOD(A)
      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Contents

      HOD(A)

      • 1 Minute to read
      • Print
      • Dark
        Light
      • PDF
      Article summary

      Engineering Functions: [HOD(A)]

      Returns the Hour portion from DateTime Field A.

      Purpose

      Use this function to:

      • Group Data into hourly segments
      • Determine hourly activity patterns across multiple days
      • Extract hour of day data for use in other calculation

      Return Value

      FieldType

      Integer

      FieldSize

      Med

      DataType

      Discrete

      DataSize

      Short

      0...23

      Parameters

      Component

      JSON

      Description

      Table

      “targetTable”: “MyTableName”

      The target table on which the new field will be created

      Filter

      “dataset”: {DataSet_JSON}

      Optional. Any records not in the filter Recordset will be returned as null by HOD(A)

      DateTime Function

      “p1”:

      HOD(A)

      A

      “p2”: “DateTimeFieldName”

      DateTime field. Required. Must be on the target table.

      The DateTime Field from which to extract Hour data.

      JSON sample

      Usage Notes

      Example

      Extract Hour of Day from TimeStamp

      • Table: = PA_All
      • Function: = DateTimeTransform
      • DateTimeFunction: = HOD(A)
      • A:= TimeStamp

       

      Was this article helpful?
      What's Next