UDC Connect: Problem with timestamp field for selection

[Former Member]

We are loading data from an Informix table with a timestamp field in it. The timestamp field is splitted in the DataSource into two fields, one for the date and one for the time. Now would like to make a selection on the timestamp field to select only the records from the last 24 hours (as an example). The problem is now that due to the splitting of timestamp field into two fields we are not able to define a correct selection. Especially when the selection should span more then one day and also considering the time.

Has everybody faced this problem before?

Thanks for your help

[Former Member]

Hi Meier,

If the Timestamp field is available in the Source Informix table....add another field to the DataSource....and select on it.

You can keep the existing Date and time fields as they are....so that you don't disturb existing setup.

Good luck, BB

[Former Member]

Dear BB,

Thanks for your answer. But I don't understand what you mean. The DataSource contains only the fields in the Informix table. I can't add additional ones. I'm wondering why SAP is doing the split into two fields.