The DATEFORMAT date and time function now accepts strings of data type CHAR and VARCHAR as the datetime expression to convert. Sybase IQ implicitly converts the character string to a date, time, or timestamp data type, so an explicit cast is no longer necessary.