I have columns column1 and column2. When trying to extract day, hour, minute and seconds they are coming differently in Oracle and Snowflake.
| column1 | column2 |
|---|---|
| 2016-07-19 11:31:09.165 | 2016-07-18 14:00:51.110 |
In Oracle:
select extract(day from (column1 - column2)) from table; -- returns 0
select extract(hour from (column1 - column2)) from table; -- returns 21
select extract(minute from (column1 - column2)) from table; -- returns 30
select extract(second from (column1 - column2)) from table; -- returns 17.889
In Snowflake, I used date diff but the values are very different.
1