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 vote331 views1 answer
Laravel migration sql dump
SQL
2 votes335 views2 answers
Calculate percentage in sql
SQL
3 votes373 views3 answers
Update con select postgresql
SQL
5 votes333 views2 answers
Create table mysql example auto_increment
SQL
0 vote326 views3 answers
Database restoring error
SQL
0 vote402 views1 answer
How to subquey to do not load in live database in
SQL
0 vote332 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL
0 vote341 views1 answer
Psql initialization
SQL
12 votes320 views6 answers
Select distinct
SQL
0 vote362 views1 answer
Postgres list all triggers
SQL