Oh for sure.. Actually, it would be far safer just to have an intermediary db for this purpose.
The flow would be to set the SEQ and Format at the beginning after connecting to the separate DB, Load the Temp Table, Unload as ascii, Set SEQ and Format back, Disconnect, connect to production DB, then load the file. ----- Original Message ----- From: "James Bentley" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[email protected]> Sent: Saturday, January 12, 2008 4:42 PM Subject: [RBASE-L] - Re: DATETIME String Conversion ... > Mike, > > One warning if you are going to mess with date and time formats. > You need to be the only person on the system for the duration > of you process as the canges affets all signed on. This could > have serious unfavorable consequences to any forms that accept > date input.l > > If you check my postings to this thread, it indeed can be done > in one statement. > > Jim Bentley > > --- MikeB <[EMAIL PROTECTED]> wrote: > >> OK, here is the simple way in one go... >> >> >> >> { >> Control via the Date Time Format Seq to match the input >> Don't mess with functions, they won't convert in one go to >> DateTime >> >> temp table StWills has Three cols: >> One Date and One Time one Computed to DateTime >> } >> >> SET DATE FORMAT DD-MMM-YYYY >> SET DATE SEQUENCE ddmmyyyy >> SET TIME FORMAT HH:MM:SS AP >> SET TIME SEQUENCE hhmmss >> SET VAR vstr = '03-Oct-2007 01:23:38 PM' >> INSERT INTO stwills coldate, coltime SELECT >> (SGET(.vstr,11,1)), >> (SGET(.vstr,11,13)) FROM dummy >> >> >> RETURN >> >> >> > > > Jim Bentley > American Celiac Society > [EMAIL PROTECTED] > tel: 1-504-737-3293 > > > > ____________________________________________________________________________________ > Looking for last minute shopping deals? > Find them fast with Yahoo! Search. > http://tools.search.yahoo.com/newsearch/category.php?category=shopping > > >
