Skip to content

A space we build together

MOA
Log in

[MYSQL] 생년월일로 나이 반환

MintState January 22, 2013 at 12:25 PM Views 19138

[MYSQL] 생년월일로 나이 반환

IF 문을 이용하여 나이 계산

IF (LEFT(now(),10) > ai_birth, LEFT(now(),4) - LEFT(ai_birth,4), LEFT(now(),4) - LEFT(ai_birth,4)-1) as age
Share X Facebook LINE QR code
☰ List

0 comments

Be the first to comment.