/SQL/Oracle difference between two dates in seconds

Oracle difference between two dates in seconds

Oracle difference between two dates in years

select floor(months_between(date '2012-10-10', date '2011-10-10') /12) from dual;

select floor(months_between(date '2012-10-9' , date '2011-10-10') /12) from dual;

Source: stackoverflow.com

Oracle difference between two dates in seconds

SELECT (END_DT - START_DT) * 60 * 60 * 24 FROM MY_TABLE;   	-- Seconds
SELECT (END_DT - START_DT) * 60 * 24 FROM MY_TABLE;   		-- Minutes
SELECT (END_DT - START_DT) * 24 FROM MY_TABLE;   			-- Hours

Similar codes

0 vote260 views1 answer
Drop view sql
SQL
0 vote204 views4 answers
Postgresql between month
SQL
0 vote203 views1 answer
Postgres set default schema
SQL
0 vote221 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
0 vote368 views1 answer
Current month transactions in mysql
SQL
8 votes206 views2 answers
Alert table name mysql
SQL
0 vote188 views1 answer
Best way to bind parameters to SqlCommand C#
SQL
65 votes575 views6 answers
Sql add column to table
SQL
0 vote221 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote250 views1 answer
Kimball data warehouse sql calendar
SQL