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
