/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 vote157 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote153 views1 answer
Oracle right characters
SQL
2 votes155 views1 answer
Get hour from date sql
SQL
-1 vote197 views4 answers
Sql view postgresql
SQL
8 votes124 views1 answer
Oracle current date plus 1 month
SQL
2 votes180 views2 answers
Python escape string for sql
SQL
2 votes142 views1 answer
Sql to char function with date
SQL
8 votes180 views4 answers
Reset SQL auto increment
SQL
0 vote160 views1 answer
Provide hardcoded value in the mysql query
SQL
0 vote156 views1 answer
Mysql Digital Ocean connection problems
SQL