From: czezz <czezz@o2.pl>
To: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: Albe Laurenz <laurenz.albe@wien.gv.at>
Cc: pgsql-admin@postgresql.org
Subject: Re: display to_timestamp in quotas or convert to char ?
Date: Tue, 05 May 2015 16:21:08 +0200
Message-ID: <79bfc5f9.244b3aa3.5548d1d4.9c8af@o2.pl> (raw)
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>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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ł(a):
> On May 5, 2015, at 7:24 AM, czezz <czezz@o2.pl> wrote:
> >
> > have already tried to convert timestamp to char like you suggested but that lead to another error.
> >
> > First, simply execution with NO conversion - to make sure it works like that:
> > Server2=# 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)
> >
> > Secondly, to_char():
> > Server2=# select to_char(to_timestamp('2015-05-04 22:13:14.000', 'YYYY/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.
> >
> > And this HINT seems to be odd.
>
> WHY are you still trying to convert to_char??? Convert the varchar field to_timestamp and be done with it.
>
>
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: czezz@o2.pl, scott_ribe@elevated-dev.com, laurenz.albe@wien.gv.at
Subject: Re: display to_timestamp in quotas or convert to char ?
In-Reply-To: <79bfc5f9.244b3aa3.5548d1d4.9c8af@o2.pl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox