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

4 votes109 views1 answer
SQL find text in SP
SQL
0 vote102 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote117 views1 answer
Sql describe
SQL
0 vote113 views1 answer
Less than and between in sql query
SQL
0 vote96 views1 answer
How to solve ERROR 1049 (42000): Unknown database 'hbtn_0c_0'
SQL
12 votes97 views2 answers
Delete all data in neo4j
SQL
0 vote128 views1 answer
Sql quary stuf
SQL
-1 vote106 views1 answer
Ssql to lowercqse
SQL
0 vote59 views1 answer
Resolved [java.sql.SQLException: ORA-29977: Unsupported column type for query registration in guaranteed mode ]
SQL
1 vote102 views1 answer
Wherein mysql
SQL