Trigger to convert UNIX time to timestamp without time zone.

[Alberto Olivares <alberto.olivares@xxxxxxxxxxxxxxxxxxxxx>]

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.olivares@xxxxxxxxxxxxxxxxxxxxx

Website: www.snowflakesoftware.com
Twitter: @sflakesoftware

Follow us on LinkedIn

Registered in England & Wales. Registered Number: 4294244

-----------------------------------------------------------------------------------------

Geospatial Technology Company of the Year

Read more

Geospatial Technology Company of the Year

Read more