Andrew Sullivan a...@crankycanuck.ca wrote:
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.
+1
Basically, if you want to capture a moment in time, such as when
some event happened or some
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
On 06/06/2014 06:19 AM, Alberto Olivares wrote:
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
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