[GENERAL] to_char(timestamp, format) is changing the year!

2014-11-30 Thread Stephen Woodbridge
Hi, I am have a problem when I format a timestamp in that it is changing the year. This can't be right, so either I don't understand or I have found a nasty corner case bug. This does not happen on all dates select '2014-12-31 00:00:00'::timestamp without time zone,

Re: [GENERAL] to_char(timestamp, format) is changing the year!

2014-11-30 Thread Adrian Klaver
On 11/30/2014 01:05 PM, Stephen Woodbridge wrote: Hi, I am have a problem when I format a timestamp in that it is changing the year. This can't be right, so either I don't understand or I have found a nasty corner case bug. This does not happen on all dates select '2014-12-31

Re: [GENERAL] to_char(timestamp, format) is changing the year!

2014-11-30 Thread Steve Atkins
On Nov 30, 2014, at 1:05 PM, Stephen Woodbridge wood...@swoodbridge.com wrote: Hi, I am have a problem when I format a timestamp in that it is changing the year. This can't be right, so either I don't understand You're using IYYY which is the ISO year, which is based on Mondays or

Re: [GENERAL] to_char(timestamp, format) is changing the year!

2014-11-30 Thread Stephen Woodbridge
Hi Adrain, Thank you for the explanation. I was trying to send some data to a Javascript library worked with ISO dates. But you are correct I wanted not IYYY, that totally sliped by me. Thanks, -Steve On 11/30/2014 4:19 PM, Adrian Klaver wrote: On 11/30/2014 01:05 PM, Stephen