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

1 vote363 views2 answers
One to one and one to many relationship
SQL
1 vote354 views1 answer
Mysql search like order by best match
SQL
0 vote346 views1 answer
Sql make sure every user is unqiuew
SQL
0 vote338 views1 answer
Postgres create extension if not exists
SQL
5 votes376 views2 answers
Mysql dump mysql db cli
SQL
10 votes353 views2 answers
SQL rounding numbers
SQL
0 vote351 views1 answer
Connecting mySQL to STS
SQL
6 votes335 views5 answers
Mysql get last insert id
SQL
12 votes337 views2 answers
Update column data type postgres
SQL
0 vote340 views1 answer
Every Derived yable must have its own alias
SQL