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: 17289.1070383257@sss.pgh.pa.us (view raw or flat)
Thread:
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

Responses

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-2014 The PostgreSQL Global Development Group