A temp table: abbreviation; integer?
semi-convoluted SRPL?
probably all sorts of string functions might be used - depending on how you
are "seeing" the data...
I have a table that converts, for example, 199912 to Dec 1999 valid from
1950 to 2010 - gotta remember to add a few more years soon...
Regards,
Alastair.
----- Original Message -----
From: "Wills, Joseph S" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, January 11, 2008 11:01 PM
Subject: [RBASE-L] - DATETIME String Conversion ...
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
--
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.516 / Virus Database: 269.19.0/1218 - Release Date: 10/01/2008
13:32
