Postgres Pro
Downloads
Home   >   mailing lists

Thread: BUG #8183: field timestamp result to date

BUG #8183: field timestamp result to date

From
bkhamphousone@sopragroup.com
Date:
The following bug has been logged on the website:

Bug reference:      8183
Logged by:          khamphousone
Email address:      bkhamphousone@sopragroup.com
PostgreSQL version: 9.2.3
Operating system:   Linux debian
Description:        =


In a SQL script, I've got a create table command with timestamp field
inside.
Instead of creating timestamp without field zone, I get a date.

Re: BUG #8183: field timestamp result to date

From
hubert depesz lubaczewski
Date:
On wto, maj 28, 2013 at 01:36:48 +0000, bkhamphousone@sopragroup.com wrote:
> The following bug has been logged on the website:
>
> Bug reference:      8183
> Logged by:          khamphousone
> Email address:      bkhamphousone@sopragroup.com
> PostgreSQL version: 9.2.3
> Operating system:   Linux debian
> Description:
>
> In a SQL script, I've got a create table command with timestamp field
> inside.
> Instead of creating timestamp without field zone, I get a date.

Without knowing what is the command there is no chance someone can help.
Please provide the command, what you're getting, and why you think it's
a bug.

Best regards,

depesz

Re: BUG #8183: field timestamp result to date

From
Khamphousone Bounkong
Date:
SGVsbG8sDQoNClNvcnJ5IGZvciBkaXN0dXJiaW5nIHlvdSwgaXQgd2FzIG15IGZhdWx0LiBJIHdh
cyB3b3JraW5nIG9uIGEgZGlmZmVyZW50IGRhdGFiYXNlIGFuZCBjaGFuZ2luZyBqdXN0IHRoaXMg
YXR0cmlidXRlIGFuZCBub3Qgc2VlaW5nIGl0IGNoYW5nZSBtYWtlcyBtZSB0aGluayBpdCB3YXMg
YSBidWcuDQpJIGRpZG4ndCBmaW5kIHdoZXJlIEkgY2FuIGNhbmNlbCB0aGUgYnVnLg0KDQpUaGFu
ayB5b3UgdmVyeSBtdWNoLg0KDQpDaGVlcnMuDQoNCkJvdW4uDQoNCi0tLS0tTWVzc2FnZSBkJ29y
aWdpbmUtLS0tLQ0KRGXCoDogZGVwZXN6QGRlcGVzei5jb20gW21haWx0bzpkZXBlc3pAZGVwZXN6
LmNvbV0gDQpFbnZvecOpwqA6IG1hcmRpIDI4IG1haSAyMDEzIDE2OjUxDQrDgMKgOiBLaGFtcGhv
dXNvbmUgQm91bmtvbmcNCkNjwqA6IHBnc3FsLWJ1Z3NAcG9zdGdyZXNxbC5vcmcNCk9iamV0wqA6
IFJlOiBbQlVHU10gQlVHICM4MTgzOiBmaWVsZCB0aW1lc3RhbXAgcmVzdWx0IHRvIGRhdGUNCg0K
T24gd3RvLCBtYWogMjgsIDIwMTMgYXQgMDE6MzY6NDggKzAwMDAsIGJraGFtcGhvdXNvbmVAc29w
cmFncm91cC5jb20gd3JvdGU6DQo+IFRoZSBmb2xsb3dpbmcgYnVnIGhhcyBiZWVuIGxvZ2dlZCBv
biB0aGUgd2Vic2l0ZToNCj4gDQo+IEJ1ZyByZWZlcmVuY2U6ICAgICAgODE4Mw0KPiBMb2dnZWQg
Ynk6ICAgICAgICAgIGtoYW1waG91c29uZQ0KPiBFbWFpbCBhZGRyZXNzOiAgICAgIGJraGFtcGhv
dXNvbmVAc29wcmFncm91cC5jb20NCj4gUG9zdGdyZVNRTCB2ZXJzaW9uOiA5LjIuMw0KPiBPcGVy
YXRpbmcgc3lzdGVtOiAgIExpbnV4IGRlYmlhbg0KPiBEZXNjcmlwdGlvbjogICAgICAgIA0KPiAN
Cj4gSW4gYSBTUUwgc2NyaXB0LCBJJ3ZlIGdvdCBhIGNyZWF0ZSB0YWJsZSBjb21tYW5kIHdpdGgg
dGltZXN0YW1wIGZpZWxkIA0KPiBpbnNpZGUuDQo+IEluc3RlYWQgb2YgY3JlYXRpbmcgdGltZXN0
YW1wIHdpdGhvdXQgZmllbGQgem9uZSwgSSBnZXQgYSBkYXRlLg0KDQpXaXRob3V0IGtub3dpbmcg
d2hhdCBpcyB0aGUgY29tbWFuZCB0aGVyZSBpcyBubyBjaGFuY2Ugc29tZW9uZSBjYW4gaGVscC4N
ClBsZWFzZSBwcm92aWRlIHRoZSBjb21tYW5kLCB3aGF0IHlvdSdyZSBnZXR0aW5nLCBhbmQgd2h5
IHlvdSB0aGluayBpdCdzIGEgYnVnLg0KDQpCZXN0IHJlZ2FyZHMsDQoNCmRlcGVzeg0KDQo=