EPOCH time vs PG timestamp
EPOCH time vs PG timestamp
От:
Louie Kwan <lkwan@nuvo.com>
Дата:
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
Re: EPOCH time vs PG timestamp
От:
Sam Barnett-Cormack <s.barnett-cormack@lancaster.ac.uk>
Дата:
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