Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Author Topic: Converting character string to date in db2  (Read 2164 times)

0 Members and 1 Guest are viewing this topic.

swinters

    Topic Starter


    Rookie

    Converting character string to date in db2
    « on: March 05, 2010, 02:31:47 PM »
    I have a character string that represents CYYMMDD (1100305) and need to convert this to a date for a calculation against another date field.  The below code where IWNBFY is the field name and 1100305 is the value brings back 3013-07-14
    but the actual date should be 2010-03-05...any help would be appreciated.  Thanks!!!

    SELECT DATE(IWNBFY)