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