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

47 votes410 views6 answers
Add column mysql
SQL
1 vote347 views1 answer
Can not connect to mysql server
SQL
1 vote350 views1 answer
Where to locate set password for mysql
SQL
1 vote369 views1 answer
Mysql datetime with timezone offset
SQL
2 votes349 views1 answer
Oracle apex list connected users
SQL
1 vote344 views1 answer
Oracle create index if not exists
SQL
0 vote370 views1 answer
ACCEPT nome PROMPT on oracle
SQL
0 vote369 views1 answer
Csv to sqlite python
SQL
0 vote345 views1 answer
Postgres enumerated type
SQL
1 vote559 views2 answers
Sql unique rows
SQL