Subject Re: [firebird-support] How to combine date and time?
Author Ivan Prenosil
> 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 ?