数据库sql查询以计算给定数据的年龄 [英] database sql query for age calculation for given data

问题描述

我想计算年龄
给出了我的出生日期和退休日期，在某些情况下还提供了死亡日期.

逻辑是:

如果给出=死亡日期
比年龄=出生日期-死亡日期

其他
年龄=出生日期-退休日期

i want to calculate age
i am given the date of birth and date of retirement and in some cases date of death.

the logic is as:

if given = date of death
than age = date of birth - date of death

else
age = date of birth - date of retirement

推荐答案

select case when not death is null then 
datediff(year, birth, death ) -- No of years between birth and death
else datediff(year , birth, getdate() ) -- No. of years between birth and current day
end from Table_3

declare @dob datetime
declare @death datetime
declare @retire datetime
declare @date datetime

set @dob = '30-JUN-1959'
set @death = null
set @retire = '20-JAN-2010'

if @death is null
    set @date = @retire
else
    set @date = @death



    select year(@date)
     - year(@DOB)
     - case when month(@DOB) > month(@date) then 1
            when month(@DOB) < month(@date) then 0
            when day(@DOB) > day(@date) then 1
            else 0
        end as age

但是，
年龄列已经添加，我想在其中插入结果，以便每当要查看数据库时，都可以看到年龄列

the above query works but ,
age column is already added and i want to insert results in it so that whenever the database is to review, age column can be seen

这篇关于数据库sql查询以计算给定数据的年龄的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！