Re: showing records from the last 20 min

On Tue, 2003-03-18 at 13:19, Tomasz Myrta wrote:
> > I want to show all the records in a table that occurred in the last 20
> > min.
> > 
> > So, maybe something like:
> > select * from sys_logins WHERE tstamp >= now() - '00:20';
> Did you mean:
> select * from sys_logins
> WHERE tstamp >= now()-cast('20:00' as interval);

Yes, I guess I did.  ;-)  Thanks for the help.
-- 
Matthew Nuzum
cobalt@bearfruit.org
www.bearfruit.org