How to extract HH:MM from date_time stamp?

[FamilyMan]

Hi Y'all.

I'm having a heck of a time trying to show just hours and minutes based off a date_time stamp. Any ideas on how to do this? Right now I have 2023-05-06 10:00:00 for example and I just want to show 10:00. 

Thanks!

[raviteja_p]

To get the "HH:MM" from the raw timestamp use the 'time_of_day' within a dimension group of timeframes in LookML view file.

dimension_group: created_ts {
    type: time
    description: "HH:MM_datetime"
    timeframes: [
      raw,
      year,
      time_of_day
    ]
    sql: ${TABLE}.column_name ;;