Cindy,
I don't have an Oracle database to test with and I also don't know what connectivity kit you are using but the CK should convert the foreign date column into either a DF_DATE or DF_DATETIME column. My guess is that your CK isn't doing this or does not have a appropriate information for this via the <table>.int file.