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

BUG #2482: Wrong result in timestamp_in, timestamptz_in, date_in

From: "Alexander Galler" <galler(at)kuzbass(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2482: Wrong result in timestamp_in, timestamptz_in, date_in
Date: 2006-06-15 18:43:27
Message-ID: 200606151843.k5FIhRCm082846@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2482
Logged by:          Alexander Galler
Email address:      galler(at)kuzbass(dot)net
PostgreSQL version: 8.1.3
Operating system:   Windows XP
Description:        Wrong result in timestamp_in, timestamptz_in, date_in
Details: 

SET SESSION DateStyle TO ISO, YMD;
select '20.01.01 BC'::timestamp;
Result:
"2020-01-01 00:00:00 BC"
I want "20-01-01 00:00:00 BC"

select '20.01.01 BC'::timestamptz
Result:
"2020-01-01 00:00:00+06:11 BC"
I want "20-01-01 00:00:00+06:11 BC"

select '20.01.01 BC'::date
Result:
"2020-01-01 BC"
I want "20-01-01 BC"

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-06-16 03:48:37
Subject: Re: BUG #2481: select from table's join with geometries doesn't go
Previous:From: Volkan YAZICIDate: 2006-06-15 15:52:25
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale

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