From: Leif Biberg Kristensen <leif@solumslekt.org>
To: pgsql-sql@postgresql.org
Subject: Re: data import: 12-hour time w/o AM/PM
Date: Tue, 8 Feb 2011 19:25:54 +0100
Message-ID: <201102081925.54790.leif@solumslekt.org> (raw)
In-Reply-To: <20110208181400.2e88d7cc@dick.coachhouse>
References: <20110208181400.2e88d7cc@dick.coachhouse>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: leif@solumslekt.org
Subject: Re: data import: 12-hour time w/o AM/PM
In-Reply-To: <201102081925.54790.leif@solumslekt.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox