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 vote304 views1 answer
Local pg_sql to heroku pg_sql
SQL
1 vote285 views2 answers
Group_concat limit mysql
SQL
0 vote277 views1 answer
Oracle shrink table
SQL
-1 vote286 views1 answer
Sql show custom constraints
SQL
1 vote266 views4 answers
Postgres extract date from timestamp
SQL
-1 vote290 views1 answer
Phinehas Psalm 106
SQL
2 votes265 views2 answers
Postgresql date at timezone
SQL
11 votes312 views1 answer
Oracle export view ddl
SQL
0 vote275 views1 answer
Sql server pivot rows to columns
SQL
0 vote325 views3 answers
How to find all role in mysql
SQL