Re: Unix timestamp , unix timestamp with microseconds - Mailing list pgsql-general

From Tom Lane
Subject Re: Unix timestamp , unix timestamp with microseconds
Date
Msg-id 4102.1085153638@sss.pgh.pa.us
Whole thread Raw
In response to Re: Unix timestamp , unix timestamp with microseconds  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Richard Huxton <dev@archonet.com> writes:
> In. Martin Pr��ek wrote:
>> I I read the documentation well (PG 7.3.3 ) , i see that there is not a native support for  data type  UNIX
TIMESTAMPand "unix  timestamp expressed as microseconds"   
>>
>> ie  there it is  impossible to direct insert and select
>>
>> seconds_from _Epoch
>> seconds_from _Epoch (period) microseconds_part
>> seconds_from _Epochmicroseconds_part
>>
>> without  some data conversion ?

> You could use a numeric type if that's what you want -

I'd stick with the basic float representation of timestamps.  We don't
have the particular syntaxes suggested above, but the functionality is
all there, eg

regression=# select extract(epoch from now());
    date_part
------------------
 1085153447.89091
(1 row)


            regards, tom lane

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Automatically fudging query results?
Next
From: Tom Lane
Date:
Subject: Re: feature idea – automatic up