4D v16
OCIDefineDateByPos
- 4D for OCI
-
- Relational Commands
-
- OCIBindDateByName
- OCIBindDateByPos
- OCICollAppend
- OCICollAssign
- OCICollAssignElem
- OCICollGetElem
- OCICollMax
- OCICollSize
- OCICollTrim
- OCIDateAddDays
- OCIDateAddMonths
- OCIDateFromText
- OCIDateLastDay
- OCIDateNextDay
- OCIDateSysDate
- OCIDateToText
- OCIDateZoneToZone
- OCIDefineDateByPos
- OCIIterCreate
- OCIIterDelete
- OCIIterGetCurrent
- OCIIterInit
- OCIIterNext
- OCIIterPrev
- OCIRawAllocSize
- OCIRawAssignBytes
- OCIRawAssignRaw
- OCIRawPtr
- OCIRawResize
- OCIRawSize
- OCIRefAssign
- OCIRefClear
- OCIRefFromHex
- OCIRefHexSize
- OCIRefIsEqual
- OCIRefIsNull
- OCIRefToHex
- OCITableDelete
- OCITableExists
- OCITableFirst
- OCITableLast
- OCITableNext
- OCITablePrev
- OCITableSize
OCIDefineDateByPos
| OCIDefineDateByPos ( stmtp ; defnnpp ; errhp ; position ; valuep ; valuep2 ; dty ; indp ; rlenp ; rcodep ; mode ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| stmtp | Longint |
|
Handle to requested SQL query operation | |||||
|
||||||||
| defnnpp | Longint |
|
Define handle | |||||
|
|
||||||||
| errhp | Longint |
|
Error handle | |||||
|
|
||||||||
| position | Longint |
|
Position of value in list | |||||
| valuep | Pointer |
|
Buffer(s) of type specified in dty parameter | |||||
|
|
||||||||
| valuep2 | Pointer |
|
Buffer(s) of type specified in dty parameter | |||||
|
|
||||||||
| dty | Longint |
|
Datatype | |||||
| indp | Pointer |
|
Indicator variable or array | |||||
| rlenp | Pointer |
|
Array of length of data fetched | |||||
|
|
||||||||
| rcodep | Pointer |
|
Array of column-level return codes | |||||
| mode | Longint |
|
Specifies mode of operation | |||||
| Function result | Longint |
|
Status | |||||
Please refer to the OCIDefineDateByPos command in the OCI documentation provided by Oracle for more information.
Note: The OCIDefineDateByPos command is similar to the OCIDefineByPos command except that there is an additional valuep2 parameter to adapt it for working with Oracle columns of the TIMESTAMP type. For this command, the valuep parameter is a pointer to a date (C_DATE) and valuep2 is a pointer to a time (C_TIME). When both parameters are used, the command takes the date (day/month/year) from the valuep parameter and the time (hour:minute:second) from the valuep2 parameter.
See the example for Working with Oracle Date types.
Product: 4D
Theme: Relational Commands
Number:
705236
4D for OCI ( 4D v16)
