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 Woodbri
On Nov 30, 2014, at 1: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
You're using "IYYY" which is the "ISO year", which is based on Mondays or
Thursdays or something
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 00:00:00'::timest
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,
to_char('2014-12-3
