0

Creating a Date Time intervals in Data modeling tool

When creating a SQL based model, you can create a time interval column using a custom "Date time" type column (i.e 12:00,12:15,12:30,12:45, 13:00).

To do this, add a calculated column and use the following syntax (this is an example for 15 minutes time interval, you can use any interval you wish by replacing the number 15 with any number between 1-60)

 

DateFormat([Time_column], "HH:") + format((floor(number(dateFormat([Time_column], "mm")) / 15)) * 15, "%02.0f")

 

Reply

null

Content aside

  • 3 yrs agoLast active
  • 47Views
  • 1 Following