Calculate the age based on the age

Assignment Help Database Management System

Reference no: EM131474881

I have date of birth column in my table and I want to calculate the age based on the age that will reach 65 within 6 months from the date of the report generated and that would be treated as Medicare else no eligible for Medicare

I started to code in T-sql as

getdate() as today case when datediff(yy,m.date_of_birth ,getdate()) as age

case WHEN DATEADD(MONTH, DATEDIFF(YEAR,m.date_of_birth ,getdate()) ,m.date_of_birth)(I do not know wether it works )

-------

------

Make use of CASE when if possible

I need to display the age with the months too.

The logic should be in a such a way that you display the age in such a way (the condition is when the age reaches 64 yrs 6 months, it should treated as Medicare else no Medicare)?.

Reference no: EM131474881

Questions Cloud

Find the real zeros of the polynomial function : Find the real zeros of the polynomial: Use the Intermediate Value Theorem to determine if the function. Find the domain of the function.

Discuss the strategy of your organization : BUS302 - The Internet a typhoon force, a ten times force, or is it a bit of wind? Or is it a force that fundamentally alters our business

Imperfect distribution of income : In reference to labour markets in professional sports, discuss how players are paid.

Canadian treatment of foreign corporate incomes : Which of the conditions fits the Canadian treatment of foreign corporate incomes best? equal?

Calculate the age based on the age : I have date of birth column in my table and I want calculate the age based on the age that will reach 65 within 6 months from the date of the report generated

Entering foreign markets and corporate social responsibility : savvy entrepreneur, entering foreign markets and corporate social responsibility.

Determine the code words for the ten decimal digits : Determine the code words for each of the ten decimal digits in the weighted code (63 -11). The code should be self-complementing.

Linear compensated demand curve : Another friend, who happens to be a history major, sees the formula for excess burden under a linear compensated demand curve and remarks:

Discuss about the behavioral heuristics : What other statistically relevant factors did you/they fail to incorporate? How could you have altered the framing of the situation to make a better decision?

User Account

All Pages