One alternative would be to use the substring function to crop a date/time field, ie:
SQL> select cast('now' as timestamp), substring(cast('now' as timestamp) from 1 for 16) from rdb$database;
CAST SUBSTRING
================= ============
2007-08-01 15:58:04.6690 2007-08-01 15:58
HTH,
John

> -------Original Message-------
> From: ra8009 <ra8009@...>
> Subject: [firebird-support] Ignore Seconds when getting unique list of times
> Sent: 01 Aug '07 12:42
>
> I want a list of the unique times in a time field, but I don't want
> the seconds considered. When I try SELECT (DISTINCT) it takes the
> seconds in account. How can I get the query to ignore them?
>
>