Convert V_WString to date in DB

[myfriend]

Hello I have a in DB column that is a V_W string.  I would like to convert it to a date.  The database I'm using is snowflake.

When I use the formula cast ("ERDAT" as date.) before the formula a field is yyyymmdd - 20130925.  The output is 1970-08-21, which is wrong. 

[phottovy · Accepted solution]

Hi @myfriend 

You should be able to use the TO_DATE function. Try something like this:

TO_DATE(ERDAT, 'YYYYMMDD')

 https://docs.snowflake.com/en/sql-reference/functions/to_date