isc_decode_timestamp()
Go Up to API Function Reference
Translates a date and time from InterBase ISC_TIMESTAMP format into the C struct tm format.
Syntax
void isc_decode_timestamp(
ISC_TIMESTAMP *ib_date,
void *tm_date);
| Parameter | Type | Description |
|---|---|---|
|
|
|
Pointer to an eight-byte |
|
|
|
Pointer to a C |
Description
isc_decode_timestamp() translates a date retrieved from a table and stored in an ISC_TIMESTAMP variable, ib_timestamp, into a C time structure for program manipulation. Both ib_timestamp and tm_date must be declared and initialized before use. The isc_decode_timestamp() is exactly the same as the isc_decode_date() function in versions of InterBase prior to 6.0.
Use the isc_dsql family of API calls to retrieve InterBase TIMESTAMP data from a table into the ISC_TIMESTAMP structure prior to translation.
- Note: isc_decode_timestamp() does not support milliseconds, because encode/decode functions use the structure struct tm from
time.h, which does not support a fractional part for seconds.
Example
The following code fragment illustrates declaring time structures and calling isc_decode_sql_timestamp() to translate an InterBase date format into a C time format:
#include <time.h> #include <ibase.h> . . . struct tm hire_time; ISC_TIMESTAMP hire_date; . . . /* Retrieve TIMESTAMP data from a table here. */ . . . isc_decode_timestamp(&hire_date, &hire_time);
Return value
None.