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 vote143 views1 answer
Connect to nginx server mysql remotly
SQL
3 votes140 views2 answers
Funktion LOWER/UPPER sql
SQL
0 vote162 views1 answer
Permission denied postgres \copy csv command line
SQL
17 votes145 views4 answers
Postgres list users
SQL
2 votes140 views1 answer
Sql server conection string
SQL
0 vote134 views1 answer
How to count null values in sql
SQL
0 vote188 views1 answer
Oracle show running job
SQL
1 vote134 views2 answers
Mssql show database size
SQL
6 votes203 views2 answers
Non relational database
SQL
1 vote151 views2 answers
Logical operators in sql
SQL