Re: [ADMIN] EPOCH time vs PG timestamp

2004-03-10 Thread Sam Barnett-Cormack
The PG timestamp has the advantage of actually being able to cover any time, and be timezone-aware if you wish. Epoch time, obviously, is more constrained. On Wed, 10 Mar 2004, Louie Kwan wrote: > Hi All, > > I am doing a data warehouse project using postgresql and I need warehousing > data from

[ADMIN] EPOCH time vs PG timestamp

2004-03-10 Thread Louie Kwan
Hi All, I am doing a data warehouse project using postgresql and I need warehousing data from different operational systems, like, Remedy and NNM, etc... Some data is time sensetive, I am thinking to use epoch as the format of the time instead of Postgre Timestamp data type !! The challenge for