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!

[anonymous]

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 ;;