Bug in timestamp handling

Report PGNP bugs.

Bug in timestamp handling

Postby rometaidla » Tue Nov 30, 2010 9:04 am

Hi,

I think there is bug in timestamp handling. I'm exporting data from MSSQL Server 2005 to Postgre 9 with Integration Services and timestamps are getting weird values. I have table in Postgre with following structure:

CREATE TABLE my_table
(
as_timestamp timestamp without time zone,
as_string character varying
)

When I import data into this table, result is following:
as_timestamp ;as_string
"2000-05-02 15:30:13";"2000-05-02 15:16:00"
"2000-04-27 19:25:50";"2000-04-27 19:13:47"
"2000-04-28 09:54:12";"2000-04-28 09:40:35"
"2000-04-27 19:43:00";"2000-04-27 19:43:00"
"2000-04-27 20:09:34";"2000-04-27 19:56:24"
"2000-04-28 15:01:07";"2000-04-28 14:46:57"
"2000-05-02 16:03:11";"2000-05-02 15:56:44"
"2000-05-03 12:26:09";"2000-05-03 12:10:59"
"2000-05-03 19:31:48";"2000-05-03 19:15:51"
"2000-05-04 10:51:45";"2000-05-04 10:51:25"

Notice that there is some random differences. The correct on value is in as_string column. When I view data in Integration Service before Ole DB destination with Data viewer, both as_timestamp and as_string have correct values.

What could cause the problem?
Last edited by rometaidla on Wed Dec 01, 2010 12:26 am, edited 1 time in total.
rometaidla
 
Posts: 3
Joined: Tue Nov 30, 2010 8:41 am

Re: Bug in timestamp handling

Postby rometaidla » Tue Nov 30, 2010 9:35 am

Now when I convert timestamp in Integration Service to string and then back to timestamp, then it is saved correctly. So it seems like the problem could be in SSIS side also.
rometaidla
 
Posts: 3
Joined: Tue Nov 30, 2010 8:41 am

Re: Bug in timestamp handling

Postby Moderator » Tue Nov 30, 2010 11:12 pm

We'll try to reproduce the issue and will let you know what we found.

Thank you!
User avatar
Moderator
Site Admin
 
Posts: 279
Joined: Wed Oct 29, 2008 11:27 pm

Re: Bug in timestamp handling

Postby rometaidla » Wed Dec 01, 2010 12:26 am

Had mistake in my first post, we're using Postgre 9 not 5.
rometaidla
 
Posts: 3
Joined: Tue Nov 30, 2010 8:41 am


Return to Report Bugs

Who is online

Users browsing this forum: No registered users and 1 guest