| 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: | Whole Thread | Raw Message | 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
| 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? |