ComputerScienceExpert

(11)

$18/per page/

About ComputerScienceExpert

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Applied Sciences,Calculus See all
Applied Sciences,Calculus,Chemistry,Computer Science,Environmental science,Information Systems,Science Hide all
Teaching Since: Apr 2017
Last Sign in: 103 Weeks Ago, 3 Days Ago
Questions Answered: 4870
Tutorials Posted: 4863

Education

  • MBA IT, Mater in Science and Technology
    Devry
    Jul-1996 - Jul-2000

Experience

  • Professor
    Devry University
    Mar-2010 - Oct-2016

Category > Programming Posted 09 May 2017 My Price 8.00

MySQL includes several date and time functions

Please help me with this question. 

  • MySQL includes several date and time functions. Two of these functions are CURRENT_DATE and MONTHS_BETWEEN. Use the internet to research these functions. How does the CURRENT_DATE function differ from the SYSDATE function? Are these functions available in Oracle SQL, SQL Server, and Access? Write a paragraph that discusses what the functions do and any differences and/or similarities between the functions in Oracle, SQL Server, and Access. Then perform the following tasks:
    • TAL  Distributors would like to know the number of months between the current date  and the order date of an order. Write an SQL statement in MySQL that displays  the order number and the number of months between the current date and the  order date.
    •  The number of months should display as an integer. (Hint: You can  nest one function within another function.)

 

 

  • The NOW() function in another function in MySQL that will retrieve the current date. How does it differ from the DATE() function?

Answers

(11)
Status NEW Posted 09 May 2017 01:05 AM My Price 8.00

-----------

Not Rated(0)