6 Replies Latest reply: Jul 18, 2017 4:04 AM by Muhammad Mattiullah RSS

    Need to extract hours from Time field in table

    Muhammad Mattiullah

      Hello Community,

      I need your help.I want to know that how can i extract hours from the "Time" field in table as i am trying to extract in the following way :

       

      Load

      SLUG,

      Hour("Time") as [Extracted Hours]

      from

      Source file

       

      but this query is giving me the null values in Extracted Hours column instead of giving me the hours extracted from the Time field.

      kindly suggest me some solution,

      Thanks in advance