Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 926B51337BE1 for ; Tue, 8 Feb 2011 15:15:14 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 09946-01-6 for ; Tue, 8 Feb 2011 19:15:06 +0000 (UTC) X-Greylist: delayed 00:48:53.224254 by SQLgrey-1.7.6 Received: from mail43.e.nsc.no (mail43.e.nsc.no [193.213.115.43]) by mail.postgresql.org (Postfix) with ESMTP id 122491337D0C for ; Tue, 8 Feb 2011 15:14:51 -0400 (AST) Received: from balapapa.localnet (207.100.202.84.customer.cdi.no [84.202.100.207]) (authenticated bits=0) by mail43.nsc.no (8.14.3/8.14.3) with ESMTP id p18IPtY0018352 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-SHA bits=256 verify=NOT) for ; Tue, 8 Feb 2011 19:25:56 +0100 (MET) From: Leif Biberg Kristensen To: pgsql-sql@postgresql.org Subject: Re: data import: 12-hour time w/o AM/PM Date: Tue, 8 Feb 2011 19:25:54 +0100 User-Agent: KMail/1.13.5 (Linux/2.6.36-gentoo-r5; KDE/4.4.5; x86_64; ; ) References: <20110208181400.2e88d7cc@dick.coachhouse> In-Reply-To: <20110208181400.2e88d7cc@dick.coachhouse> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Message-Id: <201102081925.54790.leif@solumslekt.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201102/35 X-Sequence-Number: 35111 On Tuesday 8. February 2011 19.14.00 Tarlika Elisabeth Schmitz wrote: > From the date and time I want to create a timestamp. > I know that > - the events take place during the day, say between 10:30 and 22:30 > - it's always a set of events at one location spaced about 30min apart > - the imported data are chained (have a link to previous/next event) > > > Have you got any idea how I could tackle this problem Add 12 hours if time is in the interval 1:00-10:30? regards, Leif