A Guide to SQL
A Guide to SQL
9th Edition
ISBN: 9781337668880
Author: Pratt
Publisher: Cengage
bartleby

Concept explainers

Expert Solution & Answer
Book Icon
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...

Blurred answer
Students have asked these similar questions
Need help answering these questions!1. Design a While loop that lets the user enter a number. The number should be multiplied by 10, and the result stored in a variable named product. The loop should iterate as long as the product contains a value less than 100.   2. Design a For loop that displays the following set of numbers: 0, 10, 20, 30, 40, 50 . . . 1000   3. Convert the While loop in the following code to a Do-While loop:     Declare Integer x = 1     While x > 0        Display "Enter a number."        Input x     End While
Need help with these:Design a While loop that lets the user enter a number. The number should be multiplied by 10, and the result stored in a variable named product. The loop should iterate as long as the product contains a value less than 100.   2. Design a For loop that displays the following set of numbers: 0, 10, 20, 30, 40, 50 . . . 1000   3. Convert the While loop in the following code to a Do-While loop:     Declare Integer x = 1     While x > 0        Display "Enter a number."        Input x     End While
Convert the While loop in the following code to a Do-While loop:    Declare Integer x = 1    While x > 0       Display "Enter a number."       Input x    End While
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning