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 vote359 views2 answers
How to type a blank discord messgae
SQL
5 votes340 views1 answer
Oracle scan source ddl
SQL
15 votes383 views6 answers
Laravel db transaction
SQL
0 vote368 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
0 vote358 views1 answer
Sql revert migration
SQL
0 vote355 views1 answer
Mysql sql.gz
SQL
0 vote356 views1 answer
Inner join distinct
SQL
1 vote329 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote381 views1 answer
Selecting Multiple Columns in SQL
SQL
0 vote352 views1 answer
Mac os zsh: command not found: mysql
SQL