/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

1 vote259 views1 answer
Postgresql Insufficient privilege: 7 ERROR: permission denied for table
SQL
15 votes215 views1 answer
Mysql int range
SQL
8 votes216 views1 answer
Declare table variable sql server
SQL
0 vote238 views1 answer
Mysql remove bad character from all fields
SQL
1 vote225 views2 answers
SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"
SQL
0 vote212 views1 answer
Sql query interview questions githu
SQL
0 vote212 views1 answer
What alter does in db
SQL
0 vote222 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
0 vote209 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote209 views2 answers
How to find sql server agent jobs related to a database
SQL