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 vote274 views1 answer
Mysql add comment to column
SQL
0 vote267 views1 answer
Mysql select last 15 minutes
SQL
0 vote268 views1 answer
Sql string contains case sensitive
SQL
2 votes293 views1 answer
Java.lang.arrayindexoutofboundsexception: index 0 out of bounds for length 0
SQL
1 vote270 views1 answer
Oracle explain plan
SQL
7 votes271 views4 answers
Database dump mysql command
SQL
19 votes289 views6 answers
Sql drop table if exists
SQL
1 vote273 views1 answer
How to check the mysql version mac
SQL
3 votes295 views1 answer
Get current month last date in sql server
SQL
4 votes273 views1 answer
Sql group by year
SQL