MapDateToDateTime – PB Docs 126

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

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

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:


Document get from Powerbuilder help
Thank you for watching.
Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x