Skip site navigation (1) Skip section navigation (2)

Re: Inserting timestamp values

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: cnliou(at)so-net(dot)net(dot)tw
Cc: "" <pgsql-docs(at)postgresql(dot)org>
Subject: Re: Inserting timestamp values
Date: 2003-12-02 16:40:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-docs
"cnliou" <cnliou(at)so-net(dot)net(dot)tw> writes:
> Does my test result comply with the statements in section 
> "8.5 Date/Time Types"?

I think so.  You are inserting into a timestamp-with-time-zone column,
so even though you mark the literal constant as timestamp without time
zone, it's going to be converted to timestamp with time zone.

			regards, tom lane

In response to


pgsql-docs by date

Next:From: Hannu KrosingDate: 2003-12-02 20:32:53
Subject: Re: Inserting timestamp values
Previous:From: cnliouDate: 2003-12-02 16:24:03
Subject: Inserting timestamp values

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group