Re: timestamp conversion to unisgned long?

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: <pierre(at)kahuna(dot)versions(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: timestamp conversion to unisgned long?
Date: 2001-06-22 19:19:45
Message-ID: Pine.LNX.4.30.0106222119270.727-100000@peter.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

pierre(at)kahuna(dot)versions(dot)com writes:

> Perhaps I'm not sing hte correct datatype, but I'd like to be able to convert
> a timestamp over to an unsigned long to be used within C code and compare
> to the output of time().

extract(epoch from your_value_here)

--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message J.Fernando Moyano 2001-06-22 21:10:39 cache lookup failed ???? What is it ???!!!
Previous Message Jeff Boes 2001-06-22 19:18:31 NOTIFY "string" from rule