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 vote153 views1 answer
Sql server list locks
SQL
0 vote177 views1 answer
Oracle execute package dblink
SQL
1 vote153 views1 answer
Oracle duration between timestamps
SQL
0 vote142 views1 answer
Oracle for loop on list
SQL
0 vote143 views1 answer
Sql make sure every user is unqiuew
SQL
13 votes161 views2 answers
Sql online compiler
SQL
1 vote158 views3 answers
Remove unique key from a table
SQL
0 vote159 views1 answer
Virtuoso sql query tutorial
SQL
0 vote144 views1 answer
How to connect postgresql database with java
SQL
1 vote195 views1 answer
Postgresql append array
SQL