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 vote144 views1 answer
Sql convert float to string
SQL
7 votes132 views5 answers
Oracle alter table
SQL
16 votes138 views2 answers
Oracle ddl
SQL
1 vote145 views1 answer
Sqlite3 read only
SQL
14 votes136 views5 answers
Set password for postgres user ubuntu
SQL
0 vote132 views1 answer
How to select only a certain date sql
SQL
0 vote128 views1 answer
Mysql repair a table
SQL
0 vote133 views1 answer
Will graphql replace sql
SQL
1 vote123 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
17 votes153 views4 answers
Mysql remove ubuntu
SQL