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

-- 
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql

Reply via email to