Need Help w/ Timestamps - Mailing list pgsql-general

From Enrico Riedel
Subject Need Help w/ Timestamps
Date
Msg-id 2816f36efd2c7eab566d204f679d8f42@www.stlouis.thunderelectricinc.com
Whole thread Raw
Responses Re: Need Help w/ Timestamps  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Re: Need Help w/ Timestamps  (Scott Marlowe <smarlowe@g2switchworks.com>)
List pgsql-general
Hi!

I moved all of our PostGRE DBs from Windows to Linux last weekend.
Everything went well, performance is great, BUT there is one issue that I
need to solve.

My problem is, that the precision for timestamps in Linux is greater than in
Windows. That seems to be fine, but MS Access cannot handle it. E.g.:

   Windows Timestamp: 2006-09-08 15:25:42.332
   Linux Timestamp:   2006-09-09 21:25:06.947069

Is there any way (even somehow through the ODBC driver) to restrict the
timestamp accuracy to "M$ Win" accuracy?

Thanks for your help!

-Enrico



pgsql-general by date:

Previous
From: Csaba Nagy
Date:
Subject: Re: plz unsubscribe me
Next
From: stig erikson
Date:
Subject: off topic - web shop