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

7 votes181 views4 answers
What is my mysql version
SQL
1 vote178 views1 answer
Mysql view current queries
SQL
11 votes191 views2 answers
Insert date sql
SQL
2 votes141 views1 answer
Mysql admin u root p password change password
SQL
2 votes177 views2 answers
How to get capital letter first in sql
SQL
0 vote186 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
14 votes183 views2 answers
Oracle add column with default value
SQL
1 vote166 views1 answer
Limit offset order by mysql
SQL
20 votes202 views1 answer
Get all table name in sql through php
SQL
0 vote171 views1 answer
Oracle db get table sizes
SQL