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

1 vote292 views1 answer
Pl sql ptint
SQL
8 votes307 views1 answer
Oracle current date plus 1 month
SQL
1 vote306 views1 answer
Psql filed name alter
SQL
3 votes278 views3 answers
How to set up an auto incrementing id db browser
SQL
25 votes290 views6 answers
Modify column name in mysql
SQL
0 vote252 views1 answer
Get only first row mysql
SQL
1 vote296 views1 answer
Rows to comma separated values in mssql
SQL
0 vote293 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
0 vote283 views1 answer
Oracle list subpartitions
SQL
14 votes295 views1 answer
Sql value of string
SQL