Thread: Datetime <> ODBC <> Access

Datetime <> ODBC <> Access

From
Bob Kruger
Date:

In looking at a linked table on MSAcess via ODBC, I noticed that the
Datetime field shows up in Access as only showing the last two digits for
the date field.  Example - today's date of 23 June 1999 shows up as 6/23/99.

Has anyone else experienced this?  If so, any hints on making the Access
side Posix/Y2K compliant?

Thanks in advance for any assistance.

Regards - Bob Kruger


Re: [GENERAL] Datetime <> ODBC <> Access

From
José Soares
Date:
Your is not a PostgreSQL problem. If you want to display a particular date
format you have to configure it
on your M$Windows.

go to:   Start->Configuration->Panel control ->
International_Configurations->Date
(I don't know if the above translation is correct, I translated it from Italian)



Bob Kruger ha scritto:

> In looking at a linked table on MSAcess via ODBC, I noticed that the
> Datetime field shows up in Access as only showing the last two digits for
> the date field.  Example - today's date of 23 June 1999 shows up as 6/23/99.
>
> Has anyone else experienced this?  If so, any hints on making the Access
> side Posix/Y2K compliant?
>
> Thanks in advance for any assistance.
>
> Regards - Bob Kruger

--
______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'