Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

SQL to C: Time

The identifier for the time ODBC SQL data type is:

SQL_TYPE_TIME

The following table shows the ODBC C data types to which time SQL data may be converted. For an explanation of the columns and terms in the table, see Converting Data from SQL to C Data Types.

C type identifier

Test

*TargetValuePtr

*StrLen_or_IndPtr

SQLSTATE

SQL_C_CHAR

BufferLength > Character byte length

9 <= BufferLength <= Character byte length

BufferLength < 9

Data

Truncated data[a]

Undefined

Length of data in bytes

Length of data in bytes

Undefined

n/a

01004

22003

SQL_C_WCHAR

BufferLength > Character length

9 <= BufferLength <= Character length

BufferLength < 9

Data

Truncated data[a]

Undefined

Length of data in characters

Length of data in characters

Undefined

n/a

01004

22003

SQL_C_BINARY

Byte length of data <= BufferLength

Byte length of data > BufferLength

Data

Undefined

Length of data in bytes

Undefined

n/a

22003

SQL_C_TYPE_TIME

None[b]

Data

6[d]

n/a

SQL_C_TYPE_TIMESTAMP

None[b]

Data[c]

16[d]

n/a

[a]   The fractional seconds of the time are truncated.

[b]   The value of BufferLength is ignored for this conversion. The driver assumes that the size of *TargetValuePtr is the size of the C data type.

[c]   The date fields of the timestamp structure are set to the current date, and the fractional seconds field of the timestamp structure is set to zero.

[d]   This is the size of the corresponding C data type.

When time SQL data is converted to character C data, the resulting string is in the "hh:mm:ss" format. This format is not affected by the Windows® country setting.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.