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 vote216 views1 answer
Mysql disable triggers
SQL
0 vote269 views1 answer
Current month transactions in mysql
SQL
0 vote200 views1 answer
Oracle c# multiple update sql
SQL
1 vote194 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
14 votes204 views4 answers
Remove record from table sql
SQL
0 vote202 views3 answers
Sql query checker
SQL
-1 vote204 views1 answer
Get id from just inserted row mysql server python
SQL
5 votes194 views3 answers
String concatenation sql server
SQL
1 vote203 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote190 views1 answer
Sql "List the contact methods found in the Contact table.For each contact method, list how many people chose that contact method."
SQL