Dates are coerced to character if no time dimension is specified for R engine.
added example
removed sqlite comment about wrong casting, because it's fixed now.