Small white great god answers, such as the 2016-01-04 40 minus 2016-01-04 10:10, how to use the SQL said

CodePudding user response:

 
SQL> 
SQL> The select to_date (' 40, 2016-01-04) - to_date (' 2016-01-01 10:10) diff_days 
2 the from dual; 
DIFF_DAYS 
-- -- -- -- -- -- -- -- -- -- 
3.1875 

SQL> 

CodePudding user response:

Direct reduction is
How many days get is

CodePudding user response:

40 to_date (' 2016-01-04 ', '- DD YYYY - MM HH24: MI: SS') - to_date (' and 2016-01-01 ', '- DD YYYY - MM HH24: MI: SS')