Home > mailing lists

problem with unixtime conversion - Mailing list pgsql-general

From	Nathan Suderman
Subject	problem with unixtime conversion
Date	January 14, 2003 15:51:03
Msg-id	se23dd50.080@groupwise6.pollstar.com Whole thread Raw
Responses	Re: problem with unixtime conversion Re: problem with unixtime conversion
List	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?

From: Bruce Momjian
Date: 14 January 2003, 15:49:55
Subject: Re: DATESTYLE

From: "Ragnar Garli"
Date: 14 January 2003, 15:55:59
Subject: Re: pg_dump fail beacuse of oid larger than int32