Postgres Pro
Downloads
Home   >   mailing lists

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

From In. Martin Prášek
Subject Unix timestamp , unix timestamp with microseconds
Date
Msg-id 000c01c43eb7$8c673d90$7600a8c0@wbp1
Whole thread Raw
Responses Re: Unix timestamp , unix timestamp with microseconds
List pgsql-general
Tree view
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  
 
 

pgsql-general by date:

Previous
From: Christopher Browne
Date:
Subject: Re: Am I locking more than I need to?
Next
From: Durai raj
Date:
Subject: postmaster shutdown failed