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) > '....'


With regards,

Martijn Tonies
Upscene Productions
http://www.upscene.com

Download Database Workbench for Oracle, MS SQL Server, Sybase SQL
Anywhere, MySQL, InterBase, NexusDB and Firebird!

Database questions? Check the forum:
http://www.databasedevelopmentforum.com