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.
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 : |