Breaking News: Grepper is joining You.com. Read the official announcement!

snowflake convert string to date

Chad Liu answered on October 27, 2022 Popularity 8/10 Helpfulness 4/10

answer snowflake convert string to date

snowflake convert string to date

Comment

select
       description,
       value,
       to_timestamp(value),
       to_date(value)
    from demo1
    order by value
    ;
+--------------+-------------------+-------------------------+----------------+
| DESCRIPTION  | VALUE             | TO_TIMESTAMP(VALUE)     | TO_DATE(VALUE) |
|--------------+-------------------+-------------------------+----------------|
| Seconds      | 31536000          | 1971-01-01 00:00:00.000 | 1971-01-01     |
| Milliseconds | 31536000000       | 1971-01-01 00:00:00.000 | 1971-01-01     |
| Microseconds | 31536000000000    | 1971-01-01 00:00:00.000 | 1971-01-01     |
| Nanoseconds  | 31536000000000000 | 1971-01-01 00:00:00.000 | 1971-01-01     |
+--------------+-------------------+-------------------------+----------------+

Popularity 8/10 Helpfulness 4/10 Language whatever

Source: docs.snowflake.com

Tags: string to-date whatever

Link to this answer
Share Copy Link