| Subject | Re: [firebird-support] How to combine date and time? |
|---|---|
| Author | Ivan Prenosil |
| Post date | 2010-02-19T02:01:34Z |
> I've legacy database where timestamp is stored in two separateThe above is correct statement :) Do you have some problems with it ?
> 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' "