Re: Date representation - Mailing list pgadmin-hackers

From Jean-Michel POURE
Subject Re: Date representation
Date
Msg-id 200204111609.38204.jm.poure@freesurf.fr
Whole thread Raw
In response to Re: Date representation  (noy <noyda@isoco.com>)
List pgadmin-hackers
> CREATE TABLE "EMPLOYEE_SYSTEM" (
>         "EMP_ID" integer,
>         "EMP_EMAIL" character varying(80),
>         "EMP_TIMESTAMP" timestamp with time zone,
> );

Your schema is correct (timestamp with time zone = timestamptz).

> > By the way, did you upgrade pgAdmin2 and odbc driver to the latest
> > version? Yes, I upgrade the driver version in windows.

Try Advanced options in ODBC and enable / disable fake index and row
versioning. Does it make it?

This problem is Access2K related: Access 2K need a timestamp value to update
records. As far as I know, this used to be the case in 7.1...

Maybe something changed since 7.1. Any idea Dave?


Cheers,
Jean-Michel

pgadmin-hackers by date:

Previous
From: noy
Date:
Subject: Re: Date representation
Next
From: Dave Page
Date:
Subject: Re: Date representation