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

2 votes153 views5 answers
SQL trigger
SQL
0 vote150 views1 answer
Horizontal join sqlite
SQL
0 vote149 views2 answers
Many to many flask-sqlalchemy
SQL
10 votes161 views1 answer
All_dependencies
SQL
0 vote141 views1 answer
How to define a save method in ruby for sql databases
SQL
1 vote159 views1 answer
Oracle drop temporary table
SQL
0 vote152 views1 answer
How to put is null in where in clause
SQL
0 vote150 views1 answer
Mysql where in keep order
SQL
15 votes152 views2 answers
How to drop database name in postgresql
SQL
0 vote239 views1 answer
"inspanel" intitle:"login" -"cannot" "Login ID" -site:luckyfish.io
SQL