Unix timestamp , unix timestamp with microseconds

From: In(dot) Martin Prášek <prasek(at)silesia(dot)cz>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Unix timestamp , unix timestamp with microseconds
Date: 2004-05-20 22:11:18
Message-ID: 000c01c43eb7$8c673d90$7600a8c0@wbp1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Thanx for help

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Beutin 2004-05-20 22:14:47 Re: problem with sorting using 'ORDER BY' when character field is filled with numerical values
Previous Message Greg Stark 2004-05-20 22:10:48 Re: ORDER BY 'DK', 'DE', DESC?