Re: display to_timestamp in quotas or convert to char ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxxx> napisał(a):

> On May 5, 2015, at 7:24 AM, czezz <czezz@xxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin





[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux