| From: | Tarlika Elisabeth Schmitz <postgresql3(at)numerixtechnology(dot)de> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: data import: 12-hour time w/o AM/PM |
| Date: | 2011-02-08 19:55:16 |
| Message-ID: | 20110208195516.72664f66@dick.coachhouse |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Wed, 9 Feb 2011 08:21:47 +1300
Andrej <andrej(dot)groups(at)gmail(dot)com> wrote:
>On 9 February 2011 07:14, Tarlika Elisabeth Schmitz
><postgresql3(at)numerixtechnology(dot)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
| Attachment | Content-Type | Size |
|---|---|---|
| event.csv | text/csv | 522 bytes |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Emi Lu | 2011-02-08 20:09:29 | Re: "select c1, method(c2) group by c1" returns all values of c2 for c1 |
| Previous Message | Rolando Edwards | 2011-02-08 19:51:37 | Re: "select c1, method(c2) group by c1" returns all values of c2 for c1 |