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