TO_CHAR - Convert Datetime to String - Informix to Oracle Migration - SQLines
Informix and Oracle provide TO_CHAR function to convert a datetime value to a string using the specified format, but format strings are different. Informix: -- Convert the current date and time to string (year-month-day) SELECT TO_CHAR(TODAY, '%Y-%m-%d .....