Hi, I have similar kind of question, i am trying to compare two date columns (from two diffrent tables). Table1's date column  SOURCE_TIMESTAMP char(26) format=$CHAR26. informat=$CHAR26., Table 2's date column is SOURCE_TIMESTAMP num format=DATETIME26.6 informat=DATETIME26.6 label='SOURCE_TIMESTAMP', how to convert Table1's column to DATETIME datatype, so that i can compare between these two tables ? Thanks for your help ... View more