> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Martijn Tonies
> Sent: Wednesday, December 21, 2005 3:23 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Re: Comparing Time portion of
> Date in query
>
> > > > Does anyone know how to compare only the Time portion of a Date
> > > > field? If just run query "Select * from MyTable where Time1 <
> > Time2"

<snip>

> > "Client SQL dialect 1 does not support reference to TIME datatype".
>
> Ah, right ... you're using Dialect 1.
>
> Well, as you noticed, Dialect 1 doesn't do "time". I think
> the best bet is using an UDF to transform the time part into
> a value you can compare.

FreeUDFLib has a stripdate function (as well as other UDF's I believe)
that will strip the date portion of the date/time. I use that quite a
bit, works like a charm.