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

11 votes167 views1 answer
Sql query to find duplicates in column
SQL
31 votes181 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote189 views1 answer
Drop view in mysql
SQL
1 vote186 views1 answer
Top 10 rows in mysql
SQL
0 vote171 views1 answer
Add sqlcmd to path linux
SQL
0 vote177 views2 answers
Transaction php
SQL
0 vote159 views1 answer
Output to file mysql
SQL
1 vote174 views1 answer
Tsql update datetime
SQL
3 votes168 views1 answer
Force using index plsql
SQL
3 votes184 views2 answers
Oracle apex view logs
SQL