From: Tarlika Elisabeth Schmitz <postgresql3@numerixtechnology.de>
To: pgsql-sql@postgresql.org
Subject: Re: data import: 12-hour time w/o AM/PM
Date: Tue, 8 Feb 2011 19:55:16 +0000
Message-ID: <20110208195516.72664f66@dick.coachhouse> (raw)
In-Reply-To: <AANLkTimjNTEr0EQTtBWRTHrioO5zCSs=SzP26mCAL1H+@mail.gmail.com>
References: <20110208181400.2e88d7cc@dick.coachhouse>
<AANLkTimjNTEr0EQTtBWRTHrioO5zCSs=SzP26mCAL1H+@mail.gmail.com>
On Wed, 9 Feb 2011 08:21:47 +1300
Andrej <andrej.groups@gmail.com> wrote:
>On 9 February 2011 07:14, Tarlika Elisabeth Schmitz
><postgresql3@numerixtechnology.de> 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
Attachments:
[text/csv] event.csv (521B, ../20110208195516.72664f66@dick.coachhouse/2-event.csv)
download | inline:
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: postgresql3@numerixtechnology.de
Subject: Re: data import: 12-hour time w/o AM/PM
In-Reply-To: <20110208195516.72664f66@dick.coachhouse>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox