8 Replies Latest reply: Aug 13, 2013 8:46 AM by Ralf Becher RSS

    Make an integer a date format

      Hello,

       

      I am using an Informix database and I only want to select the records of this date.

      However, the date field has the following format:

       

      7869187

       

      The date can be calculated as follows: 9.000.000 - 7.869.187 = 1.130.813 = 113-08-13 (format 1YY-MM-DD).

      I would have to get rid of the 1 in front of the number, and create a date format.

       

      How can i accomplish this?