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 vote138 views1 answer
Sql query use select name inside where clause
SQL
0 vote119 views1 answer
Oracle locked objects
SQL
0 vote121 views1 answer
Select from another database
SQL
3 votes131 views2 answers
MySQL query to get column names
SQL
1 vote121 views1 answer
Data type and their numeric form
SQL
0 vote127 views1 answer
View to table
SQL
1 vote82 views1 answer
Flask-sqlalchemy filter_by contains
SQL
0 vote124 views1 answer
Sql pad left 0
SQL
0 vote141 views1 answer
Sort by
SQL
56 votes318 views5 answers
Psql create user
SQL