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 vote167 views1 answer
Mariadb date equals to current_date plus days
SQL
0 vote116 views1 answer
Sql server rtrim everything after character
SQL
0 vote118 views1 answer
Is not numeric sql
SQL
0 vote90 views1 answer
Export partttion and import in oracle
SQL
3 votes111 views1 answer
Sql calculate working days between two dates excluding weekends and holidays
SQL
0 vote87 views1 answer
Output to file mysql
SQL
0 vote103 views1 answer
Sql trying to delete database in use
SQL
10 votes55 views2 answers
Django mysql
SQL
0 vote125 views1 answer
Reindexing all tables sql server
SQL
0 vote99 views1 answer
Enlever les doubles espaces dans les tables postgresql
SQL