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(at)bearfruit(dot)org
www.bearfruit.org