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 vote203 views1 answer
How to select an index in oracle sql
SQL
0 vote197 views1 answer
Nueva tabla mysql
SQL
6 votes202 views1 answer
SQL insert all columns
SQL
0 vote197 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
8 votes203 views4 answers
How to calculate the age from date of birth in python
SQL
1 vote195 views1 answer
Altering the column name in MySQL to have a default value
SQL
5 votes178 views2 answers
Add column postgres with default value
SQL
0 vote190 views2 answers
How to know the character set of an oracle databes
SQL
0 vote189 views1 answer
Mysql in clausule string array
SQL
1 vote212 views1 answer
Oracle show execution plan
SQL