[BUGS] Insert statement changes timestamp value from MS Access ODBC

Please see attached text document. Thanks, Dave David Dabney OHH Database Specialist/Programmer Hollings Marine Lab 131 Fort Johnson Road Charleston, SC 29464 843.762.8984 insert into public_collection (original_collection_code, method, station_id, date_time, sampling_project_id

Re: [BUGS] Insert statement changes timestamp value from MS Access

I'm sorry, but I attached the incorrect file the first time! We are using MS Access as a frontend to import many water quality records into postgresql v. 8.0.2 on Red Hat 3 Enterprise. When importing a table of 40,000+ records something is going wrong with the timestamp field only for certain re

Re: [BUGS] Insert statement changes timestamp value from MS Access

as when I did it from MS Access. I was driving home and realized 4/1/2001 was probably when daylight savings time changed.and it was. So I'm not sure if this is a bug or not. Regards, Dave Tom Lane wrote: "David Dabney" <[EMAIL PROTECTED]> writes: I'm as

Re: [BUGS] Insert statement changes timestamp value from MS Access

the change and then import the data. We've been trying to get the scientists to use UTC.maybe this will help them understand why they should be doing that. Thanks, Dave PS Postgres rocks. Please keep up the good work! David Dabney wrote: Tom, Thanks for the quick reply and I&#