On Mon, Nov 3, 2008 at 12:01 PM, Bill Moran
<wmoran@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
>
> I'm trying to test the time in a time column to see if it's the same
> minute as the current time. I wouldn't have thought this would be
> difficult:
>
> WHERE TO_CHAR(now(), 'HH24MI') = TO_CHAR(time_column, 'HH24MI')
Use date_trunc
where date_trunc('minute',timefield)=date_trunc('minute',now());
I might have the args backwards.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
