LoginSignup
1
2

More than 5 years have passed since last update.

@rogasawara

年齢計算

Last updated at Posted at 2017-05-11
GetAge.sql
-- 年齢計算SQL
DECLARE  @今日     CHAR (8) = '20170511'  -- 今日（いつ時点での年齢か）
        ,@生年月日 CHAR (8) = 'YYYYMMDD'  -- 生年月日

SELECT
    YEAR (@今日) - YEAR (@生年月日) - 
    CASE 
      WHEN 
        RIGHT (CONVERT(CHAR, @今日, 112), 4) < RIGHT (CONVERT(CHAR, @生年月日, 112), 4) 
      THEN 1 
      ELSE 0 
    END AS 年齢
1
2
1

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
1
2