[RBASE-L] - Importing Time Values: HH:MM:SS.SSS

[Bruce Chitiea]

All:

RBGXE Latest:

I need to import Time values

... from Excel  format: hh:mm:ss.000
... to   R:BASE format: HH:MM:SS.SSS

Best import result I get in R:BASE is: HH:MM:SS

So I'm missing a step. How do I import those thousandsss?

Thanks much,
Bruce


My test code:

SET TIME SEQUENCE HHMMSS
SET TIME FORMAT HH:MM:SS.SSS

DELETE ROWS FROM TimeImportTest

GATEWAY IMPORT XLS TimeImportTest.xlsx +
       APPEND TimeImportTest +
       OPTION FIRST_ROW 2 +
       |ADD_MAPPING TimeImportID = A +
       |ADD_MAPPING TimeImportTestValue = B

SET TIME SEQUENCE HHMMSS
SET TIME FORMAT HH:MM:SS

BROWSE * FROM TimeImportTest

RETURN

--
You received this message because you are subscribed to the Google Groups 
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.