Subject Re: [firebird-support] How to combine date and time?
Author Martijn Tonies

> 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

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

Database questions? Check the forum: