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 vote224 views1 answer
Acual month sql
SQL
0 vote234 views1 answer
Allow external access to mysql
SQL
7 votes221 views2 answers
N highest salary in sql
SQL
1 vote216 views1 answer
Check message id sql server
SQL
9 votes222 views3 answers
Where in sql
SQL
6 votes223 views2 answers
Join vs union
SQL
5 votes234 views1 answer
Com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed
SQL
0 vote231 views1 answer
Mysql grant user wildcard database
SQL
4 votes234 views1 answer
Data types in sql
SQL
0 vote225 views1 answer
Grant privileges mysql to database 1064
SQL