/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 vote199 views1 answer
Compare two tables to find unmatched records
SQL
0 vote147 views1 answer
Mysql Install Ubuntu with native password
SQL
16 votes180 views1 answer
Mysql smallint range
SQL
4 votes151 views2 answers
How to delete row in sql
SQL
5 votes172 views1 answer
AND OR NOT operators sql
SQL
37 votes360 views3 answers
Sql check duplicate value in column
SQL
0 vote153 views1 answer
SAP Return
SQL
2 votes153 views2 answers
Enable foreign key checks postgres
SQL
0 vote184 views1 answer
Mysql preg replace
SQL
0 vote149 views2 answers
Pg_restore: error: input file appears to be a text format dump. Please use psql.
SQL