/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 vote110 views1 answer
Get count by weekly pivot table sql server
SQL
0 vote115 views1 answer
Stored procedures example
SQL
1 vote116 views2 answers
Regex starts with
SQL
1 vote139 views1 answer
Postgres install unaccent extension
SQL
25 votes156 views5 answers
Mysql replace text
SQL
1 vote118 views1 answer
Float precision in psql
SQL
0 vote136 views1 answer
MySQL get all previous date record
SQL
1 vote107 views4 answers
Sequelize migration default value
SQL
0 vote131 views1 answer
Oracle list user locked
SQL
27 votes119 views4 answers
Get all tables with column name sql
SQL