Need Help w/ Timestamps

From: Enrico Riedel <eriedel(at)thunderelectricinc(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Need Help w/ Timestamps
Date: 2006-09-11 15:05:14
Message-ID: 2816f36efd2c7eab566d204f679d8f42@www.stlouis.thunderelectricinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Angva 2006-09-11 15:16:00 Re: pg_dump and cluster
Previous Message Ivan Sergio Borgonovo 2006-09-11 14:59:51 Re: references/tutorial/tricks on dynamic generation of