Datetrunc hour snowflake

Snowflake datetrunc month

select to_date('2015-05-08T23:39:20.123-07:00') as "DATE1",
       date_trunc('YEAR', "DATE1") as "TRUNCATED TO YEAR",
       date_trunc('MONTH', "DATE1") as "TRUNCATED TO MONTH",
       date_trunc('DAY', "DATE1") as "TRUNCATED TO DAY";

Datetrunc hour snowflake

select to_timestamp('2015-05-08T23:39:20.123-07:00') as "TIMESTAMP1",
       date_trunc('HOUR', "TIMESTAMP1") as "TRUNCATED TO HOUR",
       date_trunc('MINUTE', "TIMESTAMP1") as "TRUNCATED TO MINUTE",
       date_trunc('SECOND', "TIMESTAMP1") as "TRUNCATED TO SECOND";

Similar codes

1 vote115 views1 answer
Show per page table in xampp
SQL
-1 vote98 views2 answers
How to select the lowest values from table per client sql
SQL
0 vote107 views2 answers
Oracle sql for each row
SQL
39 votes174 views4 answers
Select duplicates in sql
SQL
2 votes101 views2 answers
Mysql limit
SQL
0 vote116 views1 answer
Como hacer una consulta en sql
SQL
2 votes106 views2 answers
How to view created temporary tables in mysql
SQL
0 vote151 views1 answer
Do you know sql
SQL
0 vote121 views1 answer
Str_to_date sql server
SQL
3 votes98 views2 answers
Sql end of month
SQL