Convert DATETIME and INTERVAL values

can automatically convert DATETIME and INTERVAL values between database columns and host variables of character type char, string, or fixchar. converts a DATETIME or INTERVAL value to a character string and then stores it in a host variable.

You can use library functions to explicitly convert between DATE and DATETIME values.