On Sat, 30 Mar 2002, Paul DuBois wrote:
At 17:15 -0500 3/30/02, Michael Stassen wrote:
On Sat, 30 Mar 2002, Paul DuBois wrote:
At 21:25 +0100 3/30/02, Roger Baklund wrote:
* Son Nguyen
== I tried this query, but... it's not working out:
SELECT YEAR(now()-birthday) from
* Son Nguyen
== I tried this query, but... it's not working out:
SELECT YEAR(now()-birthday) from users where loginName=test;
You are very close:
SELECT YEAR(now())-YEAR(birthday) as age from users where loginName=test;
--
Roger
query
At 21:25 +0100 3/30/02, Roger Baklund wrote:
* Son Nguyen
== I tried this query, but... it's not working out:
SELECT YEAR(now()-birthday) from users where loginName=test;
You are very close:
SELECT YEAR(now())-YEAR(birthday) as age from users where loginName=test;
That won't adjust for
On Sat, 30 Mar 2002, Paul DuBois wrote:
At 21:25 +0100 3/30/02, Roger Baklund wrote:
* Son Nguyen
== I tried this query, but... it's not working out:
SELECT YEAR(now()-birthday) from users where loginName=test;
You are very close:
SELECT YEAR(now())-YEAR(birthday) as age from
At 17:15 -0500 3/30/02, Michael Stassen wrote:
On Sat, 30 Mar 2002, Paul DuBois wrote:
At 21:25 +0100 3/30/02, Roger Baklund wrote:
* Son Nguyen
== I tried this query, but... it's not working out:
SELECT YEAR(now()-birthday) from users where loginName=test;
You are very close: