e sql
server log file with pgadmin...
Thanks again.
Lou
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Monday, September 08, 2014 6:04 PM
To: Lou Oquin; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Issue with to_timestamp function
On 09/08/2014 01:52 P
*** Error **
ERROR: invalid input syntax for type timestamp with time zone: "08/06/2014
03:08:58"
SQL state: 22007
Thanks
Lou
-Original Message-
From: Jerry Sievers [mailto:gsiever...@comcast.net]
Sent: Monday, September 08, 2014 2:31 PM
To: Lou Oquin
Cc: pgsql-general@pos
I'm executing the query in pgAdmin3, in a SQL query window. The results are
coming from the history tab of the output pane.
Thanks
Lou
-Original Message-
From: Adrian Klaver [mailto:adrian.kla...@aklaver.com]
Sent: Monday, September 08, 2014 2:47 PM
To: Lou Oquin; pgsql-ge
The data is
ts
08/06/2014 03:08:58
08/06/2014 03:08:58
08/06/2014 03:08:58
Thanks
Lou
From: Melvin Davidson [mailto:melvin6...@gmail.com]
Sent: Monday, September 08, 2014 2:30 PM
To: Lou Oquin
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Issue with to_timestamp function
I suspect
I've imported a csv export of an MS SQL Server log file into a staging table on
my local install of Postgresql (9.3/UTF8 encoding) for analysis.
The staging table definition is:
CREATE TABLE sql_log_import
(
id serial NOT NULL,
ts text, -- will convert to ts when merging into sql_server_logs
