Postgres Pro
Downloads
Home   >   mailing lists

Re: Input timestamp from epoch? - Mailing list pgsql-general

From A. Kretschmer
Subject Re: Input timestamp from epoch?
Date
Msg-id 20050819075858.GE11416@webserv.wug-glas.de
Whole thread Raw
In response to Input timestamp from epoch?  (Bill Moseley <moseley@hank.org>)
List pgsql-general
Tree view 
am  19.08.2005, um  0:27:40 -0700 mailte Bill Moseley folgendes:
> I'm entering data into a Postgresql database where the input dates are
> currently in unix epoch values.  Is there a way for Postgresql to
> parse that epoch into a "timestamp(0) with time zone"?

SELECT TIMESTAMP WITH TIME ZONE 'epoch' + 1124438230 * INTERVAL '1 second';
                                          ^^^^^^^^^^
                                          your epoch


Regards, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47212,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===

pgsql-general by date:

Previous
From: "Sean Utt"
Date:
Subject: Re: [BUGS] BUG #1830: Non-super-user must be able to copy from a file
Next
From: "Sean Utt"
Date:
Subject: Re: [BUGS] BUG #1830: Non-super-user must be able to copy from a