That 'blank' Oracle database I'm converting to Rbase has every date field defined as DATETIME. I want to change all those fields to DATE values. SRPL says that DATETIME cannot be used in that function (I tried to either blank out the time or extract the date).
I basically have all the dates formatted something like 01/01/04 0:00:00. When I export the values, I get '01/01/04 0:00:00'. I replace the 0:00:00 with null and I still have '01/01/04 ' which gives an error when reloading in the table where the fields are now defined as DATE. Any ideas on how I can do this will be greatly appreciated. Claudine :)
