Re: Date representation

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: 11 April 2002 15:10
> To: noy
> Cc: pgadmin-hackers@postgresql.org
> Subject: Re: [pgadmin-hackers] Date representation
>
>
> > 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?

I think it's a PostgreSQL thing, rather than Access or psqlODBC. Now() is
returning much higher precision in the seconds than previously. May be a
post to pgsql-general@postgresql.org would help.

Regards, Dave.