|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 <
> Actually, I forgot to mention that I did try that. I get error:
> "Client SQL dialect 1 does not support reference to TIME datatype".
cast('1.1.2000 ' || substring(Time1 from 12 for 14) as timestamp) <
cast('1.1.2000 ' || substring(Time2 from 12 for 14) as timestamp)