Re: date calculation

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: MichaelHoeller(at)t-online(dot)de
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: date calculation
Date: 2003-08-22 06:42:13
Message-ID: 3F45BB45.80704@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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??

cast('1970-1-1' as timestamp)+cast(your_ticks || ' seconds' as interval)

Does anyone know better way to cast it?

Regards,
Tomasz Myrta

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2003-08-22 10:01:13 Joined deletes but one table being a subquery.
Previous Message Bertrand Petit 2003-08-22 06:32:32 Re: "SELECT IN" Still Broken in 7.4b