timestamp to int
Is there any function for converting a timestamp into an integer with the
unix seconds value? It's really easy to convert in the other direction.
-Edwin
SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40');
-- and you can replace the timestamp string with the name of a timestamp
column.
The above is in the manual, BTW.
-Mitch
----- Original Message -----
From: "Edwin Grubbs" <egrubbs@rackspace.com>
To: <pgsql-general@postgresql.org>
Sent: Tuesday, June 26, 2001 11:16 AM
Subject: [GENERAL] timestamp to int
Show quoted text
Is there any function for converting a timestamp into an integer with the
unix seconds value? It's really easy to convert in the other direction.-Edwin
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
"Mitch Vincent" <mvincent@cablespeed.com> writes:
SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40');
-- and you can replace the timestamp string with the name of a timestamp
column.The above is in the manual, BTW.
Is there a way to do it the other way around, from an integer to a
timestamp?
Tomas
On Tue, Jun 26, 2001 at 09:22:25PM +0200, Tomas Berndtsson wrote:
"Mitch Vincent" <mvincent@cablespeed.com> writes:
SELECT EXTRACT(EPOCH FROM TIMESTAMP '2001-02-16 20:38:40');
-- and you can replace the timestamp string with the name of a timestamp
column.The above is in the manual, BTW.
Is there a way to do it the other way around, from an integer to a
timestamp?
of course not. don't be silly.
certainly not date_part or to_char or to_date. they're not
mentioned in the docs, either, so don't bother looking.
(think of the time you'll save.)
in particular, on my debian system, you wouldn't look in
/usr/share/doc/postgresql-doc/html/postgres/postgres.htm
and you wouldn't do
cd /usr/share/doc/postgresql-doc/html/postgres
grep -i epoch *
that would be bad.
--
I'd concentrate on "living in the now" because it is fun
and on building a better world because it is possible.
- Tod Steward
will@serensoft.com
http://sourceforge.net/projects/newbiedoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!
will trillich <will@serensoft.com> writes:
On Tue, Jun 26, 2001 at 09:22:25PM +0200, Tomas Berndtsson wrote:
Is there a way to do it the other way around, from an integer to a
timestamp?of course not. don't be silly.
certainly not date_part or to_char or to_date. they're not
mentioned in the docs, either, so don't bother looking.
(think of the time you'll save.)in particular, on my debian system, you wouldn't look in
/usr/share/doc/postgresql-doc/html/postgres/postgres.htm
and you wouldn't docd /usr/share/doc/postgresql-doc/html/postgres
grep -i epoch *that would be bad.
I sense a touch of sarcasm. Yet, having looked (yes, before I mailed,
and now again after), I still can't find a way to create a timestamp
from an integer. You may call me stupid, but I'd be glad to see how
it's done.
Tomas
On 30 Jun 2001, Tomas Berndtsson wrote:
certainly not date_part or to_char or to_date. they're not
mentioned in the docs, either, so don't bother looking.
(think of the time you'll save.)in particular, on my debian system, you wouldn't look in
/usr/share/doc/postgresql-doc/html/postgres/postgres.htm
and you wouldn't docd /usr/share/doc/postgresql-doc/html/postgres
grep -i epoch *that would be bad.
I sense a touch of sarcasm. Yet, having looked (yes, before I mailed,
and now again after), I still can't find a way to create a timestamp
from an integer. You may call me stupid, but I'd be glad to see how
it's done.
Quite strangely, there's no argument for to_date to do conversion from
'seconds since epoch'. At any case, this is how you do it:
select 'epoch'::timestamp + (x || ' seconds')::interval
-alex
Alex Pilosov <alex@pilosoft.com> writes:
On 30 Jun 2001, Tomas Berndtsson wrote:
certainly not date_part or to_char or to_date. they're not
mentioned in the docs, either, so don't bother looking.
(think of the time you'll save.)in particular, on my debian system, you wouldn't look in
/usr/share/doc/postgresql-doc/html/postgres/postgres.htm
and you wouldn't docd /usr/share/doc/postgresql-doc/html/postgres
grep -i epoch *that would be bad.
I sense a touch of sarcasm. Yet, having looked (yes, before I mailed,
and now again after), I still can't find a way to create a timestamp
from an integer. You may call me stupid, but I'd be glad to see how
it's done.Quite strangely, there's no argument for to_date to do conversion from
'seconds since epoch'. At any case, this is how you do it:select 'epoch'::timestamp + (x || ' seconds')::interval
Thank you. That wasn't too obvious to me, but quite logical when
seeing it now.
Tomas