Unix timestamp , unix timestamp with microseconds ?

From: "NTPT" <ntpt(at)centrum(dot)cz>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Unix timestamp , unix timestamp with microseconds ?
Date: 2004-05-20 22:31:52
Message-ID: 001d01c43eba$3fdf8970$7600a8c0@wbp1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I read the documentation well (PG 7.3.3 ) , it seems 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 _Epoch(no period here)microseconds_part

without some data conversion ?

Thanx for help

Browse pgsql-general by date

  From Date Subject
Next Message Mark Harrison 2004-05-20 23:18:00 can't get async mode to deliver small batches of rows
Previous Message Thomas Beutin 2004-05-20 22:14:47 Re: problem with sorting using 'ORDER BY' when character field is filled with numerical values