Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id ACCF71337B8D for ; Tue, 8 Feb 2011 16:15:31 -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 60230-06 for ; Tue, 8 Feb 2011 20:15:24 +0000 (UTC) X-Greylist: delayed 00:30:13.702555 by SQLgrey-1.7.6 Received: from zebedee.cranntara.net (unknown [91.186.7.82]) by mail.postgresql.org (Postfix) with ESMTP id 3CFD91337B47 for ; Tue, 8 Feb 2011 16:15:24 -0400 (AST) Received: from [88.210.158.208] (helo=bolek.coachhouse) by zebedee.cranntara.net with esmtpsa (TLS1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.72) (envelope-from ) id 1PmtxK-0005j4-FD for pgsql-sql@postgresql.org; Tue, 08 Feb 2011 20:14:37 +0000 Received: from [192.168.0.32] (helo=dick.coachhouse ident=tarlika) by bolek.coachhouse with esmtp (Exim 4.69) (envelope-from ) id 1Pmtee-0003gr-9S for pgsql-sql@postgresql.org; Tue, 08 Feb 2011 19:55:16 +0000 Date: Tue, 8 Feb 2011 19:55:16 +0000 From: Tarlika Elisabeth Schmitz To: pgsql-sql@postgresql.org Subject: Re: data import: 12-hour time w/o AM/PM Message-ID: <20110208195516.72664f66@dick.coachhouse> In-Reply-To: References: <20110208181400.2e88d7cc@dick.coachhouse> X-Mailer: Claws Mail 3.5.0 (GTK+ 2.12.12; i486-pc-linux-gnu) Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="MP_/N+uK0yEcgLqdq7cx.wn5b1h" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.107 tagged_above=-5 required=5 tests=BAYES_00=-1.9, RDNS_NONE=0.793 X-Spam-Level: X-Archive-Number: 201102/43 X-Sequence-Number: 35119 --MP_/N+uK0yEcgLqdq7cx.wn5b1h Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline On Wed, 9 Feb 2011 08:21:47 +1300 Andrej wrote: >On 9 February 2011 07:14, 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) > >Any chance of seeing actual data? Might be a job for awk/perl rather >than the RDBMS. attached small CSV sample: at both locations, events start just after twelve o'clock (noon). -- Best Regards, Tarlika Elisabeth Schmitz --MP_/N+uK0yEcgLqdq7cx.wn5b1h Content-Type: text/csv; name=event.csv Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename=event.csv location_id datum otime id previous next 253 2010-09-08 01:05 942 941 943 253 2010-09-08 01:40 943 942 944 253 2010-09-08 02:10 944 943 945 253 2010-09-08 02:45 945 944 946 253 2010-09-08 03:20 946 945 947 253 2010-09-08 03:50 947 946 (null) 253 2010-09-08 12:30 941 (null) 942 9062 2010-09-08 01:00 858 857 859 9062 2010-09-08 01:35 859 858 860 9062 2010-09-08 02:05 860 859 861 9062 2010-09-08 02:40 861 860 862 9062 2010-09-08 03:15 862 861 863 9062 2010-09-08 03:45 863 862 (null) 9062 2010-09-08 12:25 857 (null) 858 --MP_/N+uK0yEcgLqdq7cx.wn5b1h--