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 vote205 views1 answer
Mysql count unique in group statement
SQL
0 vote209 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote180 views1 answer
Ms sql unique
SQL
4 votes212 views4 answers
Rollback in sql
SQL
0 vote208 views2 answers
Sql query inner join 3 tables
SQL
1 vote192 views1 answer
Check constraint to check if date greater than todays date
SQL
0 vote205 views1 answer
Every Derived yable must have its own alias
SQL
0 vote213 views1 answer
Oracle sql how to overcome 999 limit for IN
SQL
1 vote193 views1 answer
Mysql random limit 1
SQL
1 vote170 views2 answers
Show sql logs in spring boot
SQL