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 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 me is that different operational systems are using > different data format, for example, Remedy is using epoch time and NNM has > it own format.. when I do ETL ... I think I need to choose a time format and > I may prefer to use epoch time. > > Any comment or any experience ? > > Thanks in advance. > > Best regards, > Louie Kwan > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org > -- Sam Barnett-Cormack Software Developer | Student of Physics & Maths UK Mirror Service (http://www.mirror.ac.uk) | Lancaster University ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
