1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27
| SELECT TMP.DTA
, TIMESTAMPDIFF(YEAR, TMP.DTA, CURDATE()) AS age
FROM (select '1952-01-12' as DTA union all
select '1965-02-01' as DTA union all
select '1978-03-04' as DTA union all
select '1978-01-19' as DTA union all
select '1981-06-02' as DTA union all
select '1982-02-28' as DTA union all
select '1982-03-10' as DTA union all
select '1983-01-16' as DTA) as TMP
WHERE MONTH(TMP.DTA) = MONTH(NOW())
AND DAY(TMP.DTA) = DAY(NOW())
;
SELECT TMP.DTA
, TIMESTAMPDIFF(YEAR, date_format(TMP.DTA, '%Y-%m-%d'), CURDATE()) AS age
FROM (select '1952-01-12' as DTA union all
select '1965-02-01' as DTA union all
select '1978-03-04' as DTA union all
select '1978-01-19' as DTA union all
select '1981-06-02' as DTA union all
select '1982-02-28' as DTA union all
select '1982-03-10' as DTA union all
select '1983-01-16' as DTA) as TMP
WHERE MONTH(TMP.DTA) = MONTH(NOW())
AND DAY(TMP.DTA) = DAY(NOW())
; |
Partager