Andrew Sullivan 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 measurement was taken,
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 li
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 rec
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 ad
