>> > I've legacy database where timestamp is stored in two separate
>> > fields, date and time. How I can combine the values so that I can use
>> > timestamp as a criteria?
>> >
>> > Something like this: "SELECT * FROM MY_TABLE WHERE (A_DATE + A_TIME) >
>> '2010-2-18 12:00' "
>>
>> The above is correct statement :) Do you have some problems with it ?
>>
>
> Isql gives me following error message:
>
> Statement failed, SQLCODE = -902
> Dynamic SQL Error
> -expression evaluation not supported

Is A_DATE really declared as DATE, or TIMESTAMP ?