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 vote288 views1 answer
Bus source and destination equal to destination and source of another by sql query
SQL
0 vote295 views1 answer
Mysql count grouped rows
SQL
0 vote272 views1 answer
Drop check command
SQL
0 vote287 views1 answer
Django how to get query result count
SQL
0 vote315 views1 answer
Sqlite3_open_v2
SQL
0 vote291 views1 answer
Sql select merge multiple values
SQL
0 vote276 views1 answer
Select other columns with distinct
SQL
0 vote297 views2 answers
How to tun mysql on ubunto
SQL
21 votes308 views1 answer
SQL cheat sheet pdf
SQL
10 votes297 views2 answers
Show tables in schema oracle
SQL