MapDateToDateTime

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

MapDateToDateTime=value

Parameter	Description
value	Specifies whether the Oracle Date datatype is mapped to the DateTime datatype. Values are: 0 (Default) The Oracle Date datatype is not mapped to the DateTime datatype. The time part of the Date column is not retrieved. 1 The Oracle Date datatype is mapped to the DateTime datatype. The time part of the Date column is retrieved.

Parameter

Description

value

Specifies whether the Oracle Date datatype is mapped to the DateTime datatype. Values are:

0 (Default) The Oracle Date datatype is not mapped to the DateTime datatype. The time part of the Date column is not retrieved.

1 The Oracle Date datatype is mapped to the DateTime datatype. The time part of the Date column is retrieved.

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

Example 1

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:
```
SQLCA.DBParm="MapDateToDateTime=1"
```