Re: Help!!! Data Merge

>From: Mik Hobbs <BBT@bbt-ltd.demon.co.uk> >Date: Tue, 3 Dec 1996 18:22:04 +0000 >X-Informix-List-Id: <news.31199> > >I only have one suggestion. Don't. Leaving dates and times separate >makes them much easier to code with and update through ISQL. I sympathize with this sentiment -- it is often easier to handle the date and time portions separately. >So you use an extra few bytes per record, so what. Errm, picky, picky... The DATE + DATETIME HOUR TO SECOND version uses 8 bytes: 4 bytes for the DATE and 4 bytes (6 decimal digits + exponent) for the DATETIME part. The DATETIME YEAR TO SECOND version also uses 8 bytes: 14 decimal digits + exponent. Thus, there is no net gain or loss in the size of the table. >Ease of maintenance should be the main aim. >Does anyone else agree / disagree / think I'm talking bollocks ?? There's some justic in your view... >In article <57vldr$lth@lana.zippo.com>, Sham Vaidya <?@?.?> writes >>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.... Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>