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 vote175 views1 answer
Mysql order by rand limit 1 really slow
SQL
0 vote158 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote203 views1 answer
Sp help text in postgresql
SQL
3 votes170 views1 answer
Create a table with an id in mysql
SQL
0 vote176 views1 answer
Insert using condition postgres
SQL
0 vote185 views1 answer
Mssql + bit + in python orm
SQL
0 vote134 views1 answer
Mysql offset from bottom
SQL
0 vote197 views1 answer
Mysql auto increment default value with prefix month and year
SQL
0 vote160 views1 answer
Power query case when
SQL
0 vote168 views1 answer
Pl sql join 3 tables
SQL