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

104 votes337 views2 answers
Like in mysql
SQL
1 vote227 views2 answers
Begin transaction in sql
SQL
0 vote227 views1 answer
Postgresql interview questions
SQL
13 votes213 views6 answers
Current date sql
SQL
1 vote230 views1 answer
T-SQL / AZURE Reseed
SQL
1 vote220 views1 answer
Raw query must include primary key
SQL
1 vote224 views1 answer
Select dba users oracle
SQL
1 vote245 views1 answer
Oracle columns table
SQL
12 votes208 views2 answers
Delete all data in neo4j
SQL
1 vote211 views1 answer
Mysql column start with string
SQL