Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Answer clarification in date filtering exercise #30

Open
445h1f opened this issue May 13, 2023 · 0 comments
Open

Answer clarification in date filtering exercise #30

445h1f opened this issue May 13, 2023 · 0 comments

Comments

@445h1f
Copy link

445h1f commented May 13, 2023

Question:

/*
* DB: Employees
* Table: employees
* Question: Get me all the employees above 60, use the appropriate date functions
*/

I think this statement is asking to return all employees whose age is above 60 years.
So, as per the requirement 60 years 0 month 1 days should also count as age is above 60 years (60.0027397260274 after days converting in year) but answers provided returns results for those employees whose age is above >= 61 years.

I think the answer should be:
image
as it returns every employee with age above 60 counting days and months too.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant