On Tue, 8 Feb 2011 18:38:44 -
"Oliveiros d'Azevedo Cristina" wrote:
>- Original Message -
>From: "Tarlika Elisabeth Schmitz"
>To:
>Sent: Tuesday, February 08, 2011 6:14 PM
>Subject: [SQL] data import: 12-hour time w/o AM/PM
>
>
>I
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 locat
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 c
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
bruary 08, 2011 6:14 PM
Subject: [SQL] data import: 12-hour time w/o AM/PM
I am importing data in CSV format. My technique is to COPY the data
into interim tables (starting with a "z") where I analyze them, clean
up inconsistencies; eventually I will populate the "proper" tabl
I am importing data in CSV format. My technique is to COPY the data
into interim tables (starting with a "z") where I analyze them, clean
up inconsistencies; eventually I will populate the "proper" tables with
these data. (In the example below: COPY CSV into zevent, from there
populate event.)
The
