Trigger to convert UNIX time to timestamp without time zone.

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(dot)olivares(at)snowflakesoftware(dot)com
<ballal(dot)joglekar(at)snowflakesoftware(dot)com>
Website: www.snowflakesoftware.com
Twitter: @sflakesoftware <http://www,twitter(dot)com(at)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/>*