Trigger to convert UNIX time to timestamp without time zone.
| От | Alberto Olivares |
|---|---|
| Тема | Trigger to convert UNIX time to timestamp without time zone. |
| Дата | |
| Msg-id | CAGdoAzh1WKBgRHYEKf3614UqCCb4QwvDLxcH=K2BBd9px7SWww@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Trigger to convert UNIX time to timestamp without time
zone.
Re: Trigger to convert UNIX time to timestamp without time zone. |
| Список | pgsql-general |
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
Technical Consultant
Snowflake Software
Tel.: +44 (0)2380 386578
Registered in England & Wales. Registered Number: 4294244
-----------------------------------------------------------------------------------------
Geospatial Technology Company of the Year
Geospatial Technology Company of the Year
В списке pgsql-general по дате отправления: