Chapter 8, Problem 3RQ

Explanation of Solution

Adding months to a date in Oracle:

• User can add the months to a date using “ADD_MONTHS” function in Oracle.
• Syntax of “ADD_MONTHS” function is,

  ADD_MONTHS(Date, integer_value)

• From the given syntax, the “Date” represents a date time value and the “integer_value” represents the integer number.

Example:

The example of the “ADD_MONTHS” function in query concept is given below:

SELECT STUDENT_ID, ADD_MONTHS(EXAM_DATE, 2) AS MODIFIED_DATE;

The above query is used to display student ID and two months added exam date for each student from “STUDENT” table.

• From the given query, the “ADD_MONTHS” function is used to add two months for each exam date in the given “STUDENT” table and the added month is represented by “MODIFIED_DATE” using “AS” operator.

Adding months to a date in Access:

• User can add the months to a date using “DATEADD” function in SQL Server.
• Syntax of “DATEADD” function is,

  DATEADD("interval", integer_value, date)

• The given syntax contains three arguments.
  • The “interval” represents the interval of time to be added.
    • If the user wants add a month to date, then interval will be specified by “m”, “mm” or “month”.
    • For year, the interval will be specified by “year”, “yyyy” or “yy”.
    • For day, the interval will be specified by “day”, “dy” or “y”.
  • The “integer_value” represents the integer number.
  • The “Date” represents a date time value.

Example:

The example of the “DATEADD” function in query concept is given below:

SELECT STUDENT_ID, DATEADD("m", 2, EXAM_DATE) AS MODIFIED_DATE;

The above query is used to display student ID and two months added exam date for each student from “STUDENT” table...

Explanation of Solution

Adding days to a date:

• User can add a number of days to a date without using any function.
• User can add the number of days to a given date by simply placing addition operator with given integer value.

Example:

The example for adding a number of days to a date...

Explanation of Solution

Compute the number of days between two dates:

User can compute the number of days between two ...