Subject: =?UTF-8?Q?Re:_display_to=5Ftimestamp?=
 =?UTF-8?Q?_in_quotas_or_convert_to_char_=3F?=
From: =?UTF-8?Q?czezz?= <czezz@o2.pl>
To: =?UTF-8?Q?Scott_Ribe?=<scott_ribe@elevated-dev.com>
Cc: =?UTF-8?Q?Albe_Laurenz?=<laurenz.albe@wien.gv.at>,
 pgsql-admin@postgresql.org
In-Reply-To: <FA3EDC66-B5A8-461F-8EAD-48124674C7BB@elevated-dev.com>
References: <22c93a48.7dc1250c.5548946d.f29b0@o2.pl>
 <A737B7A37273E048B164557ADEF4A58B365FC46A@ntex2010a.host.magwien.gv.at>
 <70aed348.7ad50e54.5548c47d.1e1de@o2.pl>
 <FA3EDC66-B5A8-461F-8EAD-48124674C7BB@elevated-dev.com>
Mime-Version: 1.0
Message-ID: <79bfc5f9.244b3aa3.5548d1d4.9c8af@o2.pl>
Date: Tue, 05 May 2015 16:21:08 +0200
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

This is because this query is executed/hardcoded in application.
And by executing it like this I can prove devs that there is a problem.


Dnia 5 maja 2015 15:56 Scott Ribe <scott_ribe@elevated-dev.com> napisa=C5=
=82(a):

> On May 5, 2015, at 7:24 AM, czezz <czezz@o2.pl> wrote:
> >=20
> >  have already tried to convert timestamp to char like you suggested but=
 that lead to another error.
> >=20
> > First, simply execution with NO conversion - to make sure it works like=
 that:=20=20
> > Server2=3D# select to_timestamp('2015-05-04 22:13:14.000', 'YYYY/MM/DD-=
HH24:MI:SS.FF3');
> >      to_timestamp
> > ------------------------
> > 2015-05-04 22:13:14+02
> > (1 row)
> >=20
> > Secondly, to_char():
> > Server2=3D# select to_char(to_timestamp('2015-05-04 22:13:14.000', 'YYY=
Y/MM/DD-HH24:MI:SS.FF3'));
> > ERROR:  function to_char(timestamp with time zone) does not exist
> > LINE 1: select to_char(to_timestamp('2015-05-04 22:13:14.000', 'YYYY...
> >               ^
> > HINT:  No function matches the given name and argument types. You might=
 need to add explicit type casts.
> >=20
> > And this HINT seems to be odd.
>=20
> WHY are you still trying to convert to_char??? Convert the varchar field =
to_timestamp and be done with it.
>=20
>=20


--=20
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin