problem with unixtime conversion

From: "Nathan Suderman" <nathan(at)pollstar(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: problem with unixtime conversion
Date: 2003-01-14 17:50:00
Message-ID: se23dd50.080@groupwise6.pollstar.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

does anyone know why I get the following error? running postgres 7.3.1

test=> select date(date_part('epoch','now'::date)::int);
ERROR: Bad date external representation '1042502400'

better yet does anyone have a better way to convert unixtime back to
standard readable time?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lincoln Yeoh 2003-01-14 17:51:56 Re: time to restore a database
Previous Message Bruce Momjian 2003-01-14 17:48:12 Re: DATESTYLE