Re: selecting records newer than say 20 min

[Marco Simon]

select * from table where mytimestamp > (unix_timestamp - 20) ??

Gregory Machin schrieb:
> Hi
> What, is the easest way to select all the records created in the last 20 min
> stay based on a column that has a timestamp record.
>
> Many Thanks
>
> --
> Gregory Machin
> greg@stripped
> gregory.machin@stripped
> www.linuxpro.co.za
> www.exponent.co.za
> Web Hosting Solutions
> Scalable Linux Solutions
> www.iberry.info (support and admin)
>
> [phone]
>