From: holowcza@andromeda.rutgers.edu (Richard D Holowczak)
Newsgroups: comp.apps.spreadsheets,comp.databases.oracle
Subject: Oracle -> ODBC -> Lotus = Bad Dat/Time format ?
Date: 11 Nov 1994 16:22:18 -0500
Organization: Rutgers University
Lines: 27
Distribution: world
Message-ID: <3a0naa$js5@andromeda.rutgers.edu>
NNTP-Posting-Host: andromeda.rutgers.edu



Hi folks. We have the following setup:

    Oracle 7 Relational Database
    Intersolv/Q+E ODBC Driver
    Lotus 123 R4 for Windows

We can query the database and retrieve records from tables and
views.  Columns that are CHAR or NUMBER datatype come in just fine.
Columns that use the Oracle DATE datatype (which combines
date and time) come in as a bunch of ^^^^^^^^^^ characters.

Reformatting them as "General" or "Fixed" just gives a
number that is not meaningful.

Any way to convert these to real date and time ?

FWIW, doing a similar query with MS-Excel results in
actual date and time components.

Thanks for any help.


Rich Holowczak
Rutgers University
holowcza@andromeda.rutgers.edu