Thread

  1. Datetime <> ODBC <> Access

    Bob Kruger <bkruger@mindspring.com> — 1999-06-23T14:22:05Z

    
    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
    
    
    
  2. Re: [GENERAL] Datetime <> ODBC <> Access

    Jose Soares <jose@sferacarta.com> — 1999-06-24T13:14:07Z

    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'