Tom McCallum
2008-Mar-03 20:10 UTC
[Rd] DataTime field when converting between database formats
I was recently converting a MS-Access database to MySQL when I came across this error: Error in fromchar(unclass(x)) : character string is not in a standard unambiguous format The error occurs because the NULL value of a DateTime field, if not properly setup or on export to a CSV, can be set to '0000-00-00 00:00:00' which fails the NA test in R-2.6.2/src/library/base/R/datetime.R on line 32. Can I recommend that this either raises a more specific error, or that it automatically converts this value to NA and perhaps outputs a warning. For now I have fixed the incoming data, but thought I would register this behaviour in case anyone else came across it. Best, Tom