Re: Trigger to convert UNIX time to timestamp without time zone.

On Fri, Jun 06, 2014 at 02:19:50PM +0100, Alberto Olivares wrote:
> 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?

This is in the manual, section 9.8: to_timestamp(double precision)

It's always a little confusing when you go to look it up, because it's
not with the date and time functions, because it's actually a
formatting issue. (There's a cross reference, but if you don't know
this is just a formatting issue you won't know to follow the
reference.) You probably don't need a trigger, just put that in your
query.

Are you sure you want this without time zone? In my experience,
almost every time people think they want "without time zone" they
actually don't.

A

--
Andrew Sullivan
ajs(at)crankycanuck(dot)ca