From: Jens Arnfelt <jens.arnfelt@cuatro.dk>
To: pgsql-sql@postgresql.org
Subject: How to convert 3 colums to timestamp with timezone
Date: Sun, 03 Oct 2004 22:50:13 +0200
Message-ID: <41606605.9040704@cuatro.dk> (raw)
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
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: jens.arnfelt@cuatro.dk
Subject: Re: How to convert 3 colums to timestamp with timezone
In-Reply-To: <41606605.9040704@cuatro.dk>
* 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