Remove last 3 characters from a string

[bpatel-16770205]

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”

[Dawid]

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

[bpatel-16770205]

@Dawid in sql. Trying to define it in LookML

[Dawid]

What database do you use?