Postgres Pro
Downloads
Home   >   mailing lists

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

From NTPT
Subject Unix timestamp , unix timestamp with microseconds ?
Date
Msg-id 001d01c43eba$3fdf8970$7600a8c0@wbp1
Whole thread Raw
List pgsql-general
Tree view
 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  
 
 

pgsql-general by date:

Previous
From: REarly@jswcoinc.com (Rod Early)
Date:
Subject: Porting SQL Server 2000 database to PostgreSQL
Next
From: Waldo Nell
Date:
Subject: Index not being used properly