On 09/08/2014 04:18 PM, Lou Oquin wrote:
Jerry;
When I run the query you supplied, with my database
select sli.ts::timestamptz as tstamp
from public.sql_log_import sli
where sli.id <= 10;
I get the following error:
ERROR: invalid input syntax for type timestamp with time zone: "08/06/2014 03:08:58"
Aah, just realized something. When you run the query I sent in my last
post I bet you will find the values in sli.ts where entered with double
quotes:
"08/06/2014 03:08:58"
So:
test=> create table ts_test (fld_1 text);
CREATE TABLE
test=> insert into ts_test values ('"08/06/2014 03:08:58"');
INSERT 0 1
test=> select * from ts_test ;
fld_1
-----------------------
"08/06/2014 03:08:58"
(1 row)
test=> select fld_1::timestamptz from ts_test ;
ERROR: invalid input syntax for type timestamp with time zone:
""08/06/2014 03:08:58""
********** Error **********
ERROR: invalid input syntax for type timestamp with time zone: "08/06/2014 03:08:58"
SQL state: 22007
Thanks
Lou
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
