How can I calculate current age with given birthday?
create table users (
loginName char(30) NOT NULL,
first_name char(30) NOT NULL,
last_name char(30) NOT NULL,
birthday date NOT NULL,
primary key (loginName)
);
==> How can I use the function now() ?
==> I tried this query, but... it's not working out:
SELECT YEAR(now()-birthday) from users where loginName="test";
Son Nguyen
__________________________________________________
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
