Re: timestamp conversion to unisgned long? - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: timestamp conversion to unisgned long?
Date
Msg-id Pine.LNX.4.30.0106222119270.727-100000@peter.localdomain
Whole thread Raw
In response to timestamp conversion to unisgned long?  (pierre@kahuna.versions.com)
List pgsql-sql
pierre@kahuna.versions.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@gmx.net   http://funkturm.homeip.net/~peter



pgsql-sql by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: timestamp conversion to unisgned long?
Next
From: Tom Lane
Date:
Subject: Re: View performance question