Hi everyone,
I am facing a problem of transforming Text to Date type.
I have a column called Date. The format looks like this:
I used the following formula to transfer it to Date formate"
STR_TO_DATE('Date','%d-%b-%y')
but the following error message popped up.
Could you please tell me what's wrong with my formula?
Thank you in advance for the help.