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 vote222 views1 answer
Pgadmin save data greyed out
SQL
0 vote244 views1 answer
FIND LOWEST SALARY EARNER IN SQL
SQL
7 votes180 views3 answers
Add primary key to database sql
SQL
0 vote199 views1 answer
Timestamp(0) postgresql
SQL
1 vote224 views1 answer
Mysql view current queries
SQL
15 votes180 views7 answers
MYSQL
SQL
0 vote190 views1 answer
Install mysql for fedora 34
SQL
0 vote185 views1 answer
Check index sql server
SQL
9 votes195 views3 answers
Mysql show table column full description
SQL
0 vote238 views1 answer
Change mysql version to 5.7 in ubuntu
SQL