Varchar to Date or Timestamp in snowflake

You can also use to_date func and covert:

with tbl as (select '1/6/2022 6:01:00 PM'::varchar dt)
select TO_date(dt, 'mm/dd/yyyy hh:mi:ss PM')::date dt
from tbl;

Since timestamp in varchar format you can capture the date part with the following

select substr(date_sent,1,position(' ',ts))::date

Example :

with data as (select '1/6/2022 6:01:00 PM' date_sent)
select substr(date_sent,1,position(' ',date_sent))::date dt
from data

returns

2022-01-06

Related