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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-docs by date

  From Date Subject
Next Message Hannu Krosing 2003-12-02 20:32:53 Re: Inserting timestamp values
Previous Message cnliou 2003-12-02 16:24:03 Inserting timestamp values