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

0 vote111 views1 answer
Remove from table where
SQL
2 votes127 views1 answer
Drop sequence
SQL
2 votes119 views2 answers
Laravel query builder toSql
SQL
9 votes127 views5 answers
Laravel to sql
SQL
3 votes123 views2 answers
Get current year sql
SQL
3 votes115 views2 answers
Sql asc
SQL
4 votes112 views6 answers
Sql select statement
SQL
6 votes120 views1 answer
Postgresql add enum value
SQL
-2 votes121 views1 answer
Group functions in sql
SQL
0 vote133 views2 answers
Unique key
SQL