Remove last 3 characters from a string

Looker Q&A Looker
1

How do I remove the last 3 characters from a string in LookML?

For example, I have “ownername2022:03:29”

and I only want ““ownername2022:03”

2

You mean using SQL inside the sql: ;; declration of the field? Or in a Table Calculation?

3

@Dawid in sql. Trying to define it in LookML

4

What database do you use?