Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Timestamp Datatype Changing automatically to Timestamp without time zone
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
- Cc: Rajdeep Das <sendrajster(at)gmail(dot)com>, pgsql-admin(at)postgresql(dot)org
- Subject: Re: Timestamp Datatype Changing automatically to Timestamp without time zone
- Date: Tue, 30 Jun 2009 10:45:20 -0400
- Message-id: <17585.1246373120@sss.pgh.pa.us> <text/plain>
Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> writes: > If I remember correctly, the sql standard says that timestamp, alone, > means timestamp without timezone. But prior to 8.1 pgsql implemented > timestamp as timestamp with timezone. No, you're thinking of a change that happened in 7.3. regards, tom lane
- Follow-Ups:
- Re: Timestamp Datatype Changing automatically to Timestamp without time zone
- From: Scott Marlowe
- Re: Timestamp Datatype Changing automatically to Timestamp without time zone
- References:
- Timestamp Datatype Changing automatically to Timestamp without time zone
- From: Rajdeep Das
- Re: Timestamp Datatype Changing automatically to Timestamp without time zone
- From: Scott Marlowe
- Timestamp Datatype Changing automatically to Timestamp without time zone
- Prev by Date: Re: Timestamp Datatype Changing automatically to Timestamp without time zone
- Next by Date: Re: Timestamp Datatype Changing automatically to Timestamp without time zone
- Previous by thread: Re: Timestamp Datatype Changing automatically to Timestamp without time zone
- Next by thread: Re: Timestamp Datatype Changing automatically to Timestamp without time zone
- Indexes: