MapDateToDateTime database parameter
Description
Maps the Oracle Date datatype to the DateTime datatype
to enable the time part of the data to be retrieved.
Controls
-
JDB JDBC
Syntax
|
1 |
MapDateToDateTime=<span>value</span> |
|
Parameter |
Description |
|---|---|
|
value |
Specifies whether the Oracle Date datatype
|
Default
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
profileSelect 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.DbParameter="MapDateToDateTime=1"