Re: Help!!! Data Merge

As posed, it will be difficult to achieve this. If the start_time was recorded as INTERVAL HOUR TO SECOND, then this works: SELECT EXTEND(Start_Date, YEAR TO SECOND) + Start_Time AS Start_Datetime FROM TableA; I've not spent many brain-cycles on how to convert a DATETIME HOUR TO SECOND into an INTERVAL HOUR TO SECOND. For many purposes, they are very similar, except the interval is not constrained to 00:00:00 .. 23:59:59 (it covers -99:59:59 .. +99:59:59). Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: Sham.Vaidya@rmy.emory.edu >Date: 2 Dec 1996 14:32:27 -0800 >X-Informix-List-Id: <news.31123> > >I have 2 fields on table A > >start_date - type date >start_time - type datetime hour to second > >I have created a new on Table A called >start_datetime - type datetime year to second. > >Is there any way using a simple SQL statement I can concatenate start_date >and start_time into start_datetime? Any other way? Any ideas appreciated....