On Thu, Feb 18, 2010 at 3:24 PM, Martijn Tonies <m.tonies@...>wrote:

>
>
> Hi,
>
> > 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' "
>
> How about:
>
> CAST(A_DATE || ' ' || A_TIME AS TIMESTAMP) > '....'
>

Yes, this works fine. Thanks Martijn and Claudio.


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