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

4 votes196 views2 answers
REST API
SQL
0 vote179 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
0 vote201 views1 answer
Create table split string function in sql server
SQL
0 vote181 views1 answer
Add sqlite3 in lumen
SQL
5 votes180 views2 answers
Sql create tabel with primary key auto_increment code
SQL
1 vote183 views1 answer
Oracle grant on all tables in schema
SQL
1 vote180 views4 answers
Postgres extract date from timestamp
SQL
0 vote193 views1 answer
Pagination with row_number
SQL
0 vote182 views1 answer
Sql contains vs like
SQL
6 votes260 views1 answer
How to count number of rows in sql
SQL