epoch to timestamp

From: elein <elein(at)varlena(dot)com>
To: sfpug(at)postgresql(dot)org
Cc: elein <elein(at)varlena(dot)com>
Subject: epoch to timestamp
Date: 2003-08-20 17:51:01
Message-ID: 20030820105101.J13446@cookie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: sfpug

Someone tell me the easier, softer way to convert
an epoch into a timestamp.

This is the ugly way:
select ('1/1/1970'::timestamp + '968190450 seconds')::timestamp;

I should know this...

Thanks,
elein

Responses

Browse sfpug by date

  From Date Subject
Next Message David Fetter 2003-08-20 19:09:16 Re: epoch to timestamp
Previous Message David Alban 2003-08-14 20:47:17 SIG-BEER-WEST this Saturday 8/16 in San Francisco