Hi all,
I'm trying to use a select to get the latest item of news, provided that it's
within the last X days. What do I need to add to the where clause for the
select statement below:
select ndate, nauthor, nheading
from news
order by ndate desc
limit 1
*** where ndate within the last 3 months ******
;
--
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000