Oracle 通过出生日期计算年龄

sysdate 为系统日期时间，BIRTH_DATE 为表中出生日期字段SELECTCOUNT( * )FROMBARN_SWALLOW_INFOWHEREVALID_FLAG = 1AND IS_JINQIAO = 1AND TRUNC( months_between( SYSDATE, BIRTH_DATE ) / 12 ) >= 25AND TRUNC( months_between(

杭州小哥哥

7673人浏览 · 2021-09-22 09:43:24

杭州小哥哥 · 2021-09-22 09:43:24 发布

sysdate 为系统日期时间，BIRTH_DATE 为表中出生日期字段

SELECT
	COUNT( * ) 
FROM
	BARN_SWALLOW_INFO 
WHERE
	VALID_FLAG = 1 
	AND IS_JINQIAO = 1 
	AND TRUNC( months_between( SYSDATE, BIRTH_DATE ) / 12 ) >= 25 
	AND TRUNC( months_between( SYSDATE, BIRTH_DATE ) / 12 ) <= 27
	
	
	
	
SELECT
	TRUNC( ( to_char( SYSDATE, 'yyyyMMdd' ) - to_char( BIRTH_DATE, 'yyyyMMdd' ) ) / 10000 ) AS age 
FROM
	BARN_SWALLOW_INFO