sql 查询年龄

最新推荐文章于 2024-04-16 17:16:15 发布

转载最新推荐文章于 2024-04-16 17:16:15 发布 · 1.4k 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/wgx0428/p/10172314.html

文章标签：

#数据库

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        wgx
-- Create date: <Create Date, ,>
-- Description:    <Description, ,>
-- =============================================
CREATE FUNCTION [dbo].Func_GetAge
(
    @birthday bigint
)
RETURNS int
AS
BEGIN
    DECLARE @age int ;

    if(@birthday is null or LEN(@birthday)<8)
    begin
        set @age=0;
    end
    else 
    begin
        set @age=FLOOR(datediff(DY, (LEFT(@birthday, 4) + '-' + SUBSTRING(CAST(@birthday AS varchar), 5, 2) + '-' + SUBSTRING(CAST(@birthday AS varchar), 7, 2) + ' 00:00:00'), getdate()) / 365.25);
    end
    
    RETURN @age;
END
GO