MapDateToDateTime
database parameter
Description
Maps the Oracle Date datatype to the DateTime datatype to enable
the time part of the data to be retrieved.
Applies to
JDB JDBC
Syntax
|
1 |
MapDateToDateTime=value |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether the Oracle Date datatype is
|
Default value
MapDateToDateTime=0
Usage
The Oracle Date datatype stores both date and time data. When you
connect to Oracle using the Oracle JDBC Thin Driver, only the date part
of the data is retrieved. To retrieve the time part of the data, set the
MapDateToDateTime database parameter to map the datatype of Oracle Date
columns to the DateTime datatype.
Examples
To retrieve both date and time data from an Oracle Date
column:
-
Database profile
Select the Map Date to DateTime check box on the Transaction
page in the Database Profile Setup dialog box. -
Application
Type the following in code:
1SQLCA.DBParm="MapDateToDateTime=1"