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 vote402 views1 answer
Create pl/sql stored procedure
SQL
0 vote139 views1 answer
Enable full text search mysql
SQL
7 votes151 views6 answers
Mysql group concat
SQL
1 vote140 views1 answer
Show indices in mysql table
SQL
3 votes170 views1 answer
Oracle apex warn on unsaved changes
SQL
0 vote136 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote150 views1 answer
EnvironmentError: mysql_config not found
SQL
13 votes146 views3 answers
Sql online code
SQL
4 votes165 views1 answer
Ms sql truncate table vs delete
SQL
0 vote143 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL