Re: Unix timestamp , unix timestamp with microseconds

Richard Huxton <dev(at)archonet(dot)com> writes:
> In. Martin Prek wrote:
>> I I read the documentation well (PG 7.3.3 ) , i see that there is not a native support for data type UNIX TIMESTAMP and "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