Casting string to date

Looker Q&A Looker
,
1

Hi,

I have a date field in the format yyyy-mm-dd and in string type. How do I convert the string type to date type in looker?

I tried using cast and also datatype fields, giving an error.

Lookml code - dimension: e_date {
type: date
datatype: date
sql: CAST(${TABLE}.e) ;;
}

Error - Query execution failed: - Syntax error: Unexpected “)”

How to resolve this error?

Thanks in advance.

2

What is your dialect? You forgot to include what you are casting to

CAST(${TABLE}.e AS DATE)
2 Likes