SQL needs AGE function.

On Jan 6, 12:38 am, "Skybuck Flying" wrote:
>
> I want to select people from a database within a certain
> age range.

So what's the problem? Compute the range of birth dates on the client
side and stick them into your query...

> For example:
>
> Select * From TablePerson Where (Age(Birthdate) > 20) and
> (Age(Birthdate) < 9
>
> That would make it really easy.

What's wrong with this (in PHP):

$low = date('Y-m-d', strtotime('98 years ago'));
$high = date('Y-m-d', strtotime('20 years ago'))
$query = "SELECT * FROM `TablePerson` WHERE " .
"`Birthdate` > '{$low}' AND `Birthdate` < '{$high}'";
$result = mysql_query($query);

I really don't see what the problem is...

Cheers,
NC

In article ,
says...
> Ok, this weblogger guy writes:
>
> "
> Date values in SQL is always saved in "MM/DD/YY(YY)" format.

He's wrong. It may be true for some SQL engines, but not all.

> Here's a line of code to get the string in the correct format for SQL:
> FormatDateTime('mm"/"dd"/"yyyy', Now)

Only good for Access. Most client-server engines want either yyyymmdd
or yyyy-mm-dd (some will take either).

> "
>
> So I tried:
>
> where (Birthday > 01/01/1970)
>
> Seems to be working so far.
>
> So far so good.
>
> Soon I'll post some nice code, for age range selecting
>
> Bye,
> Skybuck.
>
>
>

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).