to_timestamp error between postgres version 8.3 and 9.2

From: Technical Doubts <online(dot)technicaldoubts(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: to_timestamp error between postgres version 8.3 and 9.2
Date: 2013-08-31 05:19:12
Message-ID: CAJyuQsEP6af-MzxS=utG_4AN9ziHyDEOLSmecTiRt-fD7i+jCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear Team,

I have a table with name registers_info with below columns

regid character varying,
transid bigint,
regdate timestamp without time zone,
canceldate timestamp without time zone

insert into registers_info (regid,transid,regdate,canceldate) values
('reg1',1,to_timestamp('2013-07-24','yyyy-MM-dd
hh24:mi:ss')::TIMESTAMP,to_timestamp('null','yyyy-MM-dd
hh24:mi:ss')::TIMESTAMP);

The above query works fine in Postgres 8.3 version.

But the same query when executed in postgres 9.2 its throwing below error

ERROR: invalid value "null" for "yyyy"
Detail: Value must be an integer.
From application, this cancel date might have values or it may come as null.

Kindly suggest. Thanks in advance.

--
John

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2013-08-31 05:47:00 Re: to_timestamp error between postgres version 8.3 and 9.2
Previous Message Michael Paquier 2013-08-30 12:47:19 Re: Using of replication by initdb for both nodes?