Re: Unix timestamp , unix timestamp with microseconds

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