Mike, I don't think so. Good programming tricks come from an understanding of available functions, longtime use of the product and a little thinking outside the box.
Jim Bentley --- MikeB <[EMAIL PROTECTED]> wrote: > hmmmmm... should I worry that we think similarly? > > I figured Steve could change the SGET locations from my > example himself.. > > ----- Original Message ----- > From: "James Bentley" <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" <[email protected]> > Sent: Friday, January 11, 2008 8:12 PM > Subject: [RBASE-L] - Re: DATETIME String Conversion ... > > > > Joseph, > > > > Ask and you shall receive. Try the following in v7.6 or v8.0 > in > > any earlier versions you will needed to split up the > computed > > column definition as it is too long. > > > > -- TO CONVERT EXCEL FORMATED DATETIME VALUE 'DD-MMM-YYYY > > HH:MM:SS AP' > > -- TO RBASE DATETIME VALUE. USE A TEMPORARY OR PERMANENT > TABLE > > WITH > > -- A COMPUTED COLUMN > > CREATE TEMP TABLE CNVTDATETIME (ExcelDt + > > TEXT > (23),RBDateTime=(DATETIME(RDATE((INT(SGET(ExcelDt,2,1))),+ > > (INT((SLOC(' > > JANFEBMARAPRMAYJUNJULAUGSEPOCTNOVDEC',(SGET(ExcelDt,3,+ > > > 4))))/3)),(INT(SGET(ExcelDt,4,8)))),RTIME((IFEQ((SGET(ExcelDt,2,22)),'PM',+ > > 12,0))+(INT(SGET(ExcelDt,2,13))),(INT(SGET(ExcelDt,2,16))),+ > > (INT(SGET(ExcelDt,2,19)))))) DATETIME ) > > INSERT INTO CNVTDATETIME (ExcelDt) VALUES ('03-OCT-2007 > 01:23:38 > > PM') > > RETURN > > > > Please note that there are 3 spaces in fromt of "JAN" > > > > Jim Bentley > > American Celiac Society > > --- "Wills, Joseph S" <[EMAIL PROTECTED]> wrote: > > > >> This one is challenging me. I want to take this formatted > >> DATETIME > >> value, '03-Oct-2007 01:23:38 PM', a string from EXCEL, and > >> convert it to > >> some RBase DATETIME value or separate DATE and TIME values. > I > >> know that > >> I can do RDATE||RTIME(INT_1,INT_2,INT_3), but that 3-CHAR > >> abbreviation > >> for MONTH has me stymied. > >> > >> The source is a Production DB in Oracle, to which I don't > yet > >> have any > >> access, so it's probably gonna' be difficult in the short > run > >> for me to > >> fix this by swimming upstream. > >> > >> Any thoughts? > >> > >> Thanks, > >> Steve in Memphis > >> > >> > >> J. Stephen Wills > >> Program Manager, Research Informatics > >> Office of the Vice Chancellor for Research > >> University of Tennessee Health Science Center > >> 62 S. Dunlap, Suite 400 > >> Memphis, TN 38163 > >> Office: 901-448-2389 > >> FAX : 901-448-7133 > >> > >> > >> > > > > > > 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 > > > > > > > > > Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 ____________________________________________________________________________________ Never miss a thing. Make Yahoo your home page. http://www.yahoo.com/r/hs
