X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id 3AC4BD1BAF0
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 22 Aug 2003 03:26:55 -0300 (ADT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 13167-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 22 Aug 2003 03:26:25 -0300 (ADT)
Received: from mailout02.sul.t-online.com (mailout02.sul.t-online.com
	[194.25.134.17])
	by svr1.postgresql.org (Postfix) with ESMTP id C402FD1BAD6
	for <pgsql-sql@postgresql.org>; Fri, 22 Aug 2003 03:26:23 -0300 (ADT)
Received: from umsgate01.aul.t-online.de
	by mailout02.sul.t-online.com with smtp
	id 19q5NQ-0005mq-01; Fri, 22 Aug 2003 08:26:24 +0200
Received: from webmail.t-online.de
	(JT36t4ZaQeJkUDpz6vQ2dZToBLUDAsDqLaLmrC-X6VnJ16wRDzDggE@[172.18.16.209])
	by umsgate01.bbul.t-online.de
	with smtp id 19q5NJ-1GA0tU0; Fri, 22 Aug 2003 08:26:17 +0200
To: pgsql-sql@postgresql.org
Subject: date calculation
From: MichaelHoeller@t-online.de
Date: Fri, 22 Aug 2003 08:25:51 +0200 (CEST)
Message-ID: <1061533501.3f45b73d6566d@webmail.t-online.de>
X-Approved: 5ba5d48049593ecb2L81K-Wq0uu5gj1hcn7kXkqkCCSf2qon
X-Mailer: T-Online WebMail 3.10
X-Complaints-To: abuse#webmail@t-online.com
X-Seen: false
X-ID: JT36t4ZaQeJkUDpz6vQ2dZToBLUDAsDqLaLmrC-X6VnJ16wRDzDggE@t-dialin.net
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200308/265
X-Sequence-Number: 14881


Hi there,

I have a problem calculating a date. A field carries the date as passed
seconds since Jan 1st 1970.
How can I get the date as dd.mm.yyyy out of this??

Thanks a lot 
Michael