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 vote235 views1 answer
Sql insert from excel
SQL
0 vote210 views1 answer
C# get sql min date
SQL
2 votes191 views3 answers
Postgres remove foreign key constraint
SQL
0 vote688 views1 answer
How to connect .sql data set to powerbi
SQL
4 votes258 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
27 votes241 views5 answers
Mysql set password for user
SQL
2 votes213 views5 answers
SQL trigger
SQL
0 vote193 views1 answer
Increment id in mysql
SQL
0 vote247 views1 answer
Sql character index
SQL
0 vote223 views1 answer
Postgresql inline table
SQL