Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

sfpug by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group