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 vote286 views1 answer
Java sql insert return id
SQL
-2 votes257 views1 answer
Mysql not empty
SQL
0 vote250 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote250 views1 answer
Java mysql date format
SQL
0 vote272 views1 answer
Str_to_date sql server
SQL
0 vote292 views1 answer
Pgadmin save data greyed out
SQL
4 votes265 views1 answer
What are the data types in sql
SQL
10 votes268 views1 answer
Query to find object dependencies in oracle
SQL
0 vote257 views1 answer
Generate random & unique mysql string
SQL
0 vote265 views1 answer
Sql clear table
SQL