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@aklaver.com