Re: A minute in timestamp - Mailing list pgsql-sql

* David Loh <david@bizsurf.com> [08.05.2003 10:03]:
> Hi all.
> 'select * from myTable where date_part('minute',Update_Time > - now()) = 1;'

Does it helps, if you'll try this:

select * from myTable where date_part('second', now() - Update_Time) between 55 and 65;

--

Victor Yegorov
IT Programmer, NORD/LB Latvija JSC
Fax (+371) 7323449, Phone (+371) 7077142, Mobile (+371) 9131883