Unanswered: select date as formated string plus NULL check
In a select statement, I want to convert a date to YYYYMMDD format and if the date were NULL, then set the string to 99991231.
Additionally, the same needs to be done to a timestamp, except the format is YYYYMMDDHH24MISS.
Informix is not my native language, is there somebody out there who can help with this syntax?
the oracle syntax is: select NVL(TO_CHAR(a_date_column,'YYYYMMDD'),'99991231') as d from a_table