Claudine, I have run into the same issue and have worked around it by using a temporary table that has a date column and then time column next to it (sometimes I used a text column) then moved the data from the temporary table to the regular table, leaving behind the time columns. Good luck. Mel.
-----Original Message----- From: Claudine Robbins <[EMAIL PROTECTED]> Sent: Jul 26, 2004 4:27 PM To: RBG7-L Mailing List <[EMAIL PROTECTED]> Subject: [RBG7-L] - Re: Change DateTime into Date Thanks Bill. Indeed, I can do it in Excel. Guess I was hoping there was a way to do it in Rbase :( -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Downall Sent: Monday, July 26, 2004 6:17 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Re: Change DateTime into Date Claudine, DEXTRACT(datetimevalue) is a way to get just the date from a datetime. If all the datetimes in the export file have all zeros for the hours, minutes and seconds, you can do a global replace in a text editor of every occurance of " 0:00:00" with a blank, before you do the loading. Bill On 26 Jul 2004 at 18:01, Claudine Robbins wrote: > 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. > -- Bill Downall [EMAIL PROTECTED] 317.297.3810 ******************************** Notice: The ISP for our domain, SBC Ameritech, is currently having a problem keeping up with the volume of email and spam going through their mail servers. This means that sometimes mail gets through to and from us immediately, and sometimes the SBC Ameritech web hosting mail servers get constipated, so that delivery of mail to or from downallconsulting.com can be delayed by as much as half a day. If your message is urgent, please follow up with a telephone call. *****************************************
