Received: from mhub1.lvs.dupont.com (mhub1.lvs.dupont.com [206.241.18.2]) by hub.org (8.9.2/8.9.1) with ESMTP id IAA86480 for ; Wed, 31 Mar 1999 08:09:50 -0500 (EST) (envelope-from Marco.Iannacone@DEU.dupont.com) From: Marco.Iannacone@DEU.dupont.com Received: from mhub7.lvs.dupont.com by mhub1.lvs.dupont.com with ESMTP; Wed, 31 Mar 1999 07:47:04 -0500 Received: from euoisa.nib.dupont.com by mhub7.lvs.dupont.com; Wed, 31 Mar 1999 03:46:33 -0500 Received: from this_workstation.bhg.dupont.com ([52.168.12.59]) by euoisb.nib.dupont.com with SMTP; Wed, 31 Mar 1999 10:44:30 +0200 (CET-DST) X-Sender: iannacm@52.168.108.1 X-Mailer: QUALCOMM Windows Eudora Pro Version 4.0 Date: Wed, 31 Mar 1999 09:44:59 +0100 To: pgsql-sql@postgresql.org Subject: merging date and time Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Message-Id: <3701e0e92542002@mhub7.lvs.dupont.com> Hi, I'm experiencing some problems to create a view in which I put together a date and a time in the same field... I have a table which contain a date field (with a date inside) and a varchar field with time inside.. This is the content of those two field in one record: |22-03-1999|14:45:27 I just wanted to create a view in which those two field are merged in a datetime filed.. I tried using different approach but I'm always getting an error message or while creating the view or when selectin from the created view.. examples: create view glob_time as select datetime(euigw.day||euigw.time) as tempo from euigw; gives me the following error message; ERROR: There is more than one possible operator '||' for types 'date' and 'varc har' You will have to retype this query using an explicit cast create view glob_time as select datetime(text(euigw.day)||euigw.time) as tempo from euigw; works file, but then if I do select * from glob_time; I get: ERROR: Bad datetime external representation 'Mon 22 Mar 00:00:00 1999 MET14:45: 27' does anyone have an idea about how to solve this? thanks, Marco