Call Level Interface Guide and Reference
The time SQL data type is:
- SQL_TIME
Table 206. Converting Time SQL Data to C Data
| fCType
| Test
| rgbValue
| pcbValue
| SQLSTATE
|
| SQL_C_CHAR
| cbValueMax >= 9
| Data
| 8
| 00000
|
| cbValueMax < 9
| Untouched
| 8
| 22003
|
| SQL_C_TIME
| None a
| Data
| 6 b
| 00000
|
| SQL_C_TIMESTAMP
| None a
| Data c
| 16 b
| 00000
|
| Note: |
- a
- The value of cbValueMax is ignored for this conversion. The
driver assumes that the size of rgbValue is the size of the C data
type.
- b
- This is the size of the corresponding C data type.
- c
- The date fields of the TIMESTAMP_STRUCT structure are set to the current
system date of the machine that the application is running, and the time
fraction is set to zero.
|
SQLSTATE 00000 is not returned by SQLError(), rather
it is indicated when the function returns SQL_SUCCESS.
|
When the time SQL data type is converted to the character C data type, the
resulting string is in the "hh:mm:ss" format.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
[ DB2 List of Books |
Search the DB2 Books ]