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

15 votes353 views2 answers
Select where duplicate mysql
SQL
0 vote328 views2 answers
How to list all values of a column that start with a letter in sql
SQL
2 votes344 views4 answers
Sql query interview questions
SQL
2 votes351 views1 answer
Flask sqlalchemy boolean field
SQL
34 votes406 views6 answers
Alter table add foreign key mysql
SQL
0 vote333 views1 answer
Convert .mdf to .bak
SQL
3 votes332 views3 answers
Django.db.utils.OperationalError: no such table:
SQL
0 vote360 views1 answer
Oracle NLS_CHARACTERSET
SQL
9 votes318 views1 answer
Identity insert on sql server
SQL
1 vote356 views1 answer
Oracle nvl2
SQL