Re: data import: 12-hour time w/o AM/PM - Mailing list pgsql-sql

From Leif Biberg Kristensen
Subject Re: data import: 12-hour time w/o AM/PM
Date
Msg-id 201102081925.54790.leif@solumslekt.org
Whole thread Raw
In response to data import: 12-hour time w/o AM/PM  (Tarlika Elisabeth Schmitz <postgresql3@numerixtechnology.de>)
List 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


pgsql-sql by date:

Previous
From: "Oliveiros d'Azevedo Cristina"
Date:
Subject: Re: data import: 12-hour time w/o AM/PM
Next
From: Andrej
Date:
Subject: Re: data import: 12-hour time w/o AM/PM