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 vote240 views1 answer
Mysql_num_fields in mysqli
SQL
27 votes276 views5 answers
Mysql set password for user
SQL
0 vote255 views1 answer
Sql remove decimal places
SQL
0 vote252 views1 answer
Sql server datetime
SQL
4 votes259 views1 answer
Refresh postgres config
SQL
7 votes234 views1 answer
Mysql unsafe update
SQL
4 votes265 views4 answers
Rollback in sql
SQL
0 vote283 views1 answer
Add week ending date sql server
SQL
3 votes234 views1 answer
Mysql UPDate with enner join
SQL
3 votes267 views1 answer
Oracle list privileges
SQL