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 vote167 views1 answer
Geopoint from json mysql function
SQL
0 vote157 views1 answer
Mysql to get column name in database
SQL
0 vote169 views1 answer
Sql query to find duplicate email address
SQL
0 vote155 views1 answer
Opensuse status MySQL
SQL
0 vote153 views1 answer
Coalesce for comma separated in sql server
SQL
0 vote194 views1 answer
SQL-Arten
SQL
0 vote151 views1 answer
Sql how to display two atributes as one in sql
SQL
2 votes164 views1 answer
How to make multiple keys as primary in bdms
SQL
36 votes162 views6 answers
Rename table sql
SQL
0 vote194 views1 answer
ALV GRID events
SQL