2 Replies Latest reply: Jul 24, 2016 5:46 PM by Sunny Talwar RSS

    Create a field for Hour of Day from Timestamp

    Michael Weber

      I have a timestamp field in my data and I need to create a new field that only shows a value for the hour of day in a 24 hour format.  E.g. original timestamp shows 07/24/2016 2:15:32PM and I need to create a dimension field called "Hour of Day" that would only show the value "14" (2PM in 24hr format).

       

      Original timestamp field (named date_created) is coming in this format: YYYY-MM-DD hh:mm:ss

       

      Thanks!