Postgres Pro
Downloads
Home   >   mailing lists

How to convert 3 colums to timestamp with timezone - Mailing list pgsql-sql

From Jens Arnfelt
Subject How to convert 3 colums to timestamp with timezone
Date
Msg-id 41606605.9040704@cuatro.dk
Whole thread Raw
Responses Re: How to convert 3 colums to timestamp with timezone
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Concurrency problem
Next
From: Bruno Wolff III
Date:
Subject: Re: How to convert 3 colums to timestamp with timezone