Or with quotes around the whole field: 'mm/dd/yyyy hh:mm:ss' Another thought: are you sure that you do/don't have thousands of seconds defined and are/not loading them?
Regards, Alastair. ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, February 12, 2003 10:02 PM Subject: [RBASE-L] - Re: Loading data into datetime field - Razzak'sReply > Claudine - have you tried loading to separate date and time fields? Sometimes the system takes a space as a delimiter on a load like this. > > "Claudine Robbins" <[EMAIL PROTECTED]> wrote: > > >Razzak, > >I changed the idquote to ` but still load nulls instead of datetime > >values, all other fields load correctly. Some tables load w/no error > >messages, others with "excess values will be ignored"... > >My load command is: > >LOAD DA_COMPANIES FROM D:\COMPANIES.CSV AS CSV > >~Claudine :) > > > >-----Original Message----- > >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of A. > >Razzak Memon > >Sent: Wednesday, February 12, 2003 3:11 PM > >To: RBASE-L Mailing List > >Subject: [RBASE-L] - Re: Loading data into datetime field - > >Razzak'sReply > > > > > >Claudine, > > > >Check the database SETtings for QUOTES and IDQUOTES. > > > >CONNect dbname IDENTIFIED BY UserID Password > >SHOW CHAR > > > >Very Best Regards, > > > >Razzak. > > > > > >At 02:32 PM 2/12/2003 -0600, Claudine Robbins wrote: > > > >>I am struggling with loading data from a .csv file into a db table with > >>datetime fields. I am matching the format in RBase to the data in the > >>.csv file mm/dd/yyyy and hh:mm:ss but this setting and every variation > >>yields the same result: -0- in the field. And I know I have done this > >>successfully in the past... Any ideas? ~Claudine > > > > > > > -- > Albert Berry > Full Time Consultant to > PSD Solutions > 350 West Hubbard, Suite 210 > Chicago, IL 60610 > 312-828-9253 Ext. 32 > > > __________________________________________________________________ > The NEW Netscape 7.0 browser is now available. Upgrade now! http://channels.netscape.com/ns/browsers/download.jsp > > Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ >
