How to convert 3 colums to timestamp with timezone

From: Jens Arnfelt <jens(dot)arnfelt(at)cuatro(dot)dk>
To: pgsql-sql(at)postgresql(dot)org
Subject: How to convert 3 colums to timestamp with timezone
Date: 2004-10-03 20:50:13
Message-ID: 41606605.9040704@cuatro.dk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi There!

Hope this is an easy one :-D

How do I convert 3 individuel colums with type "date", "time" and
"integer" to at timestamp with timexone?

eg. tabel
cStartUnixtime cStartTime cStartZone
09-24-2004 10:27:12 -2

This I have to present as an timestamp with timezone.

Thanks in advance
Jens Arnfelt

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2004-10-03 21:27:25 Re: Stable function semantics (was Re: Mislabeled timestamp functions)
Previous Message Tom Lane 2004-10-03 17:15:50 Re: Concurrency problem