Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2004
    sydney, australia

    Post 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
    Last edited by raylade; 11-10-04 at 22:25.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts