Conversion Functions

Go Up to Function Categories

The following table summarizes the InterBase API functions available for translating between InterBase DATE, TIME and TIMESTAMP format and the UNIX date format, and for reversing the byte-order of an integer:

Date and conversion functions

Function name	Purpose
isc_decode_sql_date()	Translate a date from InterBase format to C struct tm format.
isc_encode_sql_date()	Translate a date from C struct tm format to InterBase format.
isc_decode_sql_time()	Translate a time from InterBase format to C struct tm format.
isc_encode_sql_time()	Translate a time from C tm format to InterBase format.
isc_decode_timestamp()	Translate a date and time from InterBase format to C struct tm format.
isc_encode_timestamp()	Translate a date and time from C struct tm format to InterBase format.
isc_portable_integer()	Reverse the byte-order of an integer.

Note: To provide backward compatibility, the isc_encode_date() and isc_decode_date() functions are still available. They behave exactly like isc_encode_timestamp() and isc_decode_timestamp().