| From: | "A(dot) Kretschmer" <akretschmer(at)despammed(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Input timestamp from epoch? |
| Date: | 2005-08-19 07:58:58 |
| Message-ID: | 20050819075858.GE11416@webserv.wug-glas.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 ===
| From | Date | Subject | |
|---|---|---|---|
| Next Message | dknoto | 2005-08-19 08:10:41 | How disable context view in RAISE |
| Previous Message | Sean Utt | 2005-08-19 07:46:29 | Re: BUG #1830: Non-super-user must be able to copy from a file |