Re: [BUGS] BUG #6340: to_timestamp() miscalculates

2011-12-23 Thread Robert Haas
On Fri, Dec 16, 2011 at 3:43 AM, Hans-Henrik Fuxelius wrote: > It seems not possible to suppress to_timestamp from doing daylight > saving conversion, I have GPS timeseries that looks perfect in the > 'timestamp without time zone' save one value that wreck the whole time > serie, does that mean th

Re: [BUGS] BUG #6340: to_timestamp() miscalculates

2011-12-16 Thread Hans-Henrik Fuxelius
It seems not possible to suppress to_timestamp from doing daylight saving conversion, I have GPS timeseries that looks perfect in the 'timestamp without time zone' save one value that wreck the whole time serie, does that mean that time series cant be stored in time stamps? /Hans-Henrik On Thu, D

Re: [BUGS] BUG #6340: to_timestamp() miscalculates

2011-12-15 Thread Hans-Henrik Fuxelius
Thanx a lot for your promt respons :) You are absolutely right, its the daylight saving that date and hour, I had it as an key in my GPS data and was very confused!!! Again - Thanx /Hans-Henrik On Dec 15, 2011, at 5:20 PM, Kevin Grittner wrote: > wrote: > >> test to run: select to_timestamp('2

Re: [BUGS] BUG #6340: to_timestamp() miscalculates

2011-12-15 Thread Kevin Grittner
wrote: > test to run: select to_timestamp('2011,03,27,02,11,11', > ',MM,DD,HH24,MI,SS') > > and the run: select to_timestamp('2011,03,27,03,11,11', > ',MM,DD,HH24,MI,SS') > > It miscalculates 02 hour to 03 hour by some reason I don't know what time zone you're in, or whether daylight

Re: [BUGS] BUG #6340: to_timestamp() miscalculates

2011-12-15 Thread Tom Lane
hfuxel...@gmail.com writes: > test to run: select to_timestamp('2011,03,27,02,11,11', > ',MM,DD,HH24,MI,SS') > and the run: select to_timestamp('2011,03,27,03,11,11', > ',MM,DD,HH24,MI,SS') > It miscalculates 02 hour to 03 hour by some reason If that date is a DST forward transition date

[BUGS] BUG #6340: to_timestamp() miscalculates

2011-12-15 Thread hfuxelius
The following bug has been logged on the website: Bug reference: 6340 Logged by: Hans-Henrik Fuxelius Email address: hfuxel...@gmail.com PostgreSQL version: 9.1.1 Operating system: Ubuntu 11.10 Description: test to run: select to_timestamp('2011,03,27,02,11,11', '