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 vote98 views2 answers
Denormalization in sql
SQL
1 vote101 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote144 views1 answer
Find and replace query in wordpress\
SQL
1 vote138 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
0 vote156 views1 answer
How to drop a trigger in postgresql
SQL
1 vote142 views1 answer
Psql connections
SQL
49 votes222 views6 answers
Get duplicate records in sql
SQL
25 votes147 views6 answers
Modify column name in mysql
SQL
1 vote165 views1 answer
Sql sort column by date
SQL
0 vote149 views1 answer
Postgres sequence name
SQL