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
Snowflake Software



Registered in England & Wales. Registered Number: 4294244
-----------------------------------------------------------------------------------------


Geospatial Technology Company of the Year



Geospatial Technology Company of the Year

В списке pgsql-general по дате отправления:

Предыдущее
От: Stefan Froehlich
Дата:
Сообщение: interpret bytea output as text / double encode()
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: interpret bytea output as text / double encode()