informix- datetime manipulation
- by asdf
Hi,
i have 2 fields in a table test1
onlydate Date
onlytime DATETIME HOUR to MINUTE
and 1 fields in a table test2
dateandtime DATETIME YEAR to SECOND
now i need to append the value of onlydate and onlytime field and set it to dateandtime field.
Please help.