>> > 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 ?