Hello, I want to insert data into a column "timestamp without time zone" data type. The problem is I am receiving the data in UNIX time.
How can I create a trigger to transform the time from UNIX to timestamp without time zone every time a new record is inserted into my database? Thank you in advance. Regards, Alberto. *Alberto Olivares Colas*Technical Consultant Snowflake Software Tel.: +44 (0)2380 386578 Email: alberto.oliva...@snowflakesoftware.com <ballal.jogle...@snowflakesoftware.com> Website: www.snowflakesoftware.com Twitter: @sflakesoftware <http://www,twitter.com@sflakesoftware/> Follow us on LinkedIn <http://www.linkedin.com/company/snowflake-software> Registered in England & Wales. Registered Number: 4294244 ----------------------------------------------------------------------------------------- *Geospatial Technology Company of the Year* *Read more <http://www.snowflakesoftware.com/2014/05/geospatial-awards/>* -- *Geospatial Technology Company of the Year* *Read more <http://www.snowflakesoftware.com/2014/05/geospatial-awards/>*