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 vote192 views1 answer
R write csv without index
SQL
2 votes242 views1 answer
Select a certain number of entries from select mysql
SQL
0 vote181 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote208 views1 answer
T-SQL - Where Used List (Table/View)
SQL
-2 votes286 views1 answer
How-to-remove-mysql-root-password
SQL
0 vote167 views1 answer
SQL division of an integer by another integer get float CAST
SQL
0 vote180 views1 answer
Create_engine sqlalchemy with parsed url sql server
SQL
0 vote191 views2 answers
Oracle chain rules
SQL
0 vote187 views1 answer
Tsql cmd exec script from file
SQL
0 vote191 views1 answer
How to write if case in select query in select statement
SQL