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"
********** Error **********
ERROR: invalid input syntax for type timestamp with time zone: "08/06/2014
03:08:58"
SQL state: 22007
So what do you get if you do:
select sli.ts
from public.sql_log_import sli
where sli.id <= 10;
Thanks
Lou
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
