Informatics Practices
Date() and Day() return the same thing.
SQL Queries
2 Likes
Answer
False
Reason — The DATE()
function extracts the date part of the date or datetime expression, whereas the DAY()
function returns the day part of a date.
Answered By
2 Likes
Related Questions
Length() is a numeric function.
Functions MID() and SUBSTR() do the same thing.
INSTR() and SUBSTR() work identically.
Assertion. Single row functions when applied on a column in a table, yield multiple values equal to number of rows in the table.
Reason. Single row functions work with individual rows and yield values accordingly.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.