On Fri, Feb 19, 2010 at 4:01 AM, Ivan Prenosil <Ivan.Prenosil@...>wrote:

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

>
>

[Non-text portions of this message have been removed]