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

8 votes143 views4 answers
How to calculate the age from date of birth in python
SQL
0 vote124 views1 answer
Remove default constraint sql server
SQL
0 vote134 views1 answer
How to save data in database in mysql node
SQL
0 vote132 views1 answer
Rabbitmq ui not working
SQL
0 vote110 views1 answer
Mysql sleep connections
SQL
0 vote139 views3 answers
Magento 2 order delete from db
SQL
0 vote131 views2 answers
Mysql decimal remove trailing zeros
SQL
0 vote120 views1 answer
Partitioning in oracle-base
SQL
0 vote137 views1 answer
Mysql workbench procedure
SQL
0 vote136 views1 answer
Oracle allow space to user
SQL