We have a datetime dimension being read from BigQuery, the problem is on Looker it converts the time value to Zeros.
Is there anyone to retain the time value?
dimension_group: placed_at_local {
type: time
datatype: date
timeframes: [
raw,
hour,
time,
date,
]
sql: ${TABLE}.placed_at_local ;;
}
Solved! Go to Solution.
Thank you @Kehinde , the first suggestion worked for me. My mistake was using
datatype: date
which ignored the timestamp
datatype: datetime
corrected that.