Re: data import: 12-hour time w/o AM/PM

From: Leif Biberg Kristensen <leif(at)solumslekt(dot)org>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: data import: 12-hour time w/o AM/PM
Date: 2011-02-08 18:25:54
Message-ID: 201102081925.54790.leif@solumslekt.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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 data are chained (have a link to previous/next event)
>
>
> Have you got any idea how I could tackle this problem

Add 12 hours if time is in the interval 1:00-10:30?

regards,
Leif

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Oliveiros d'Azevedo Cristina 2011-02-08 18:38:44 Re: data import: 12-hour time w/o AM/PM
Previous Message Tarlika Elisabeth Schmitz 2011-02-08 18:14:00 data import: 12-hour time w/o AM/PM