Question

Splitting a date string

  • 7 July 2021
  • 1 reply
  • 23 views

Hello, 

 

I am trying split a date and time string into separate date and time components, i.e. 01/04/2020 11:45:00 into 01/04/2020 and 11:45:00.

 

Can anyone help me create the a custom dimension or custom table calculation for this?  


1 reply

This has to be defined as a custom dimension and not within the view file itself?

I’m not certain how to do this just as a dimension because, for whatever reason, you cant cast in a custom dimension. But you can cast in a custom calculation.

substring(to_string(${the_model.the_datetime_dimension}),1,10)

substring(to_string(${the_model.the_datetime_dimension}),12,8)

 

If you can do this in the model itself, though, that is the best idea. Your database dialect will certainly have the appropriate functions to do this correctly.

Reply