Type Conversion Error after migrating from 8.3 to 9.2

From: Hariraman Jayaraj <ocpdreams(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Type Conversion Error after migrating from 8.3 to 9.2
Date: 2013-05-13 11:04:14
Message-ID: CANkM0DjmMZP51QaLMQSxvrTdf2TOzjsQjFjfbfufx6GRr13nkw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Dear Team,

We are using Postgres 9.2 in suse linux 11 Enterprise server.
Recently we have migrated from 8.3 to 9.2 directly using pg_dump and
pg_restore as we are not using much postgres extensions.
Restore was successful and our application running fine.
But in some inserts where we use like
*to_timestamp('8-5-2013 22:00:02','dd-mm-yyyy hh:mi:ss')::TIMESTAMP*
it throws error as
hour "22" is invalid for the 12-hour clock.
But the same insert is working with version 8.3
Only after modifying the to_timestamp with 24hour clock i.e.,
*to_timestamp('8-5-2013 22:00:02','dd-mm-yyyy hh24:mi:ss')::TIMESTAMP*, its
working fine in version 9.2
Is there any other workaround available instead of modifying multiple
queries as lot of our application coding has this conversion.

Thanks in advance.

Thanks,
Franc.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Richard Poole 2013-05-13 13:10:21 Re: Type Conversion Error after migrating from 8.3 to 9.2
Previous Message prakhar jauhari 2013-05-13 07:23:13 Steps to switch from Master to standby mode :