Chapter 8, Problem 10TD

Explanation of Solution

a.

MONTHS_BETWEEN ():

The function “MONTHS_BETWEEN” is used to return the number of months between dates. If the “date1” is future than “date2”, then the result is positive. If the “date1” is previous than “date2”, then the result is negative.

Syntax:

MONTHS_BETWEEN (DATE1, DATE2)

Example:

Consider an example for the “MONTHS_BETWEEN ()” function in Oracle is as follows:

 SELECT MONTHS_BETWEEN (TO_DATE ('11-03-2019', 'MM/DD/YYYY'), TO_DATE ('06-16-2014', 'MM/DD/YYYY')) "Months" FROM DUAL;

 Explanation:

 The above query is used to display the difference between “11-03-2019” and “06-16-2014” dates.

 Difference between “CURRENT_DATE” and “SYSDATE” function:

 

“CURRENT_DATE” function	“SYSDATE” function
The “CURRENT_DATE” function is used to return the current date. Depending on user input (numeric or string), it will return the current date in “YYYY-MM-DD” OR “YYYYMMDD” format.	The “SYSDATE” function is used to return the current date and time for the operating system of the user location.
The syntax for “CURRENT_DATE” is “CURRENT_DATE ();”	The syntax for “SYSDATE” is “SYSDATE ();”

 Functions in Oracle, SQL Server and Access:

 “No”, the “MONTHS_BETWEEN ()” function is not available in SQL Server, and Access, but other functions are present in the Oracle, SQL Server, and Access.

• The “DATEDIFF” function can be used to return the number of months given a starting date and an ending date in the SQL Server.

“MONTHS_BETWEEN ()” in Oracle:

• The function “MONTHS_BETWEEN” is used to return the number of months between dates.
• Syntax is “MONTHS_BETWEEN (DATE1, DATE2)”
• Example is “SELECT MONTHS_BETWEEN (TO_DATE ('11-03-2019', 'MM/DD/YYYY'), TO_DATE ('06-16-2014', 'MM/DD/YYYY')) "Months" FROM DUAL;”...

Explanation of Solution

b.

Difference between “NOW ()” and “DATE ()” function:

“NOW ()”function	“DATE ()” function
The “NOW ()” function is used to return the current date and time in Access...