Re: Issue with to_timestamp function

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