DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following can sometimes be used in calculations?
|
|
Labels
|
|
|
Values
|
|
|
Dates and Times
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The DateDiff function is used to calculate the difference of time between two given dates or time values. It is used to count the number of years, months, days, minutes, seconds, etc. between a StartDate and an EndDate.
Detailed explanation-2: -The GETDATE() function returns the current database system date and time, in a ‘YYYY-MM-DD hh:mm:ss.mmm’ format. Tip: Also look at the CURRENT TIMESTAMP function.
There is 1 question to complete.