I’m working with R and SQL, and some of the work uses SQLite, and some of the work uses Oracle. There are subtle differences between the two, and for that matter between any two database programs. While there are SQL standards, most packages have minor deviations, or enhancements. Dates in Oracle represent one deviation. In particular, Oracle does not use the ISO 8601 standard date format (yyyy-mm-dd) by default. Here’s a nice overview of how to work with Oracle dates.
Kristian Widjaja, Jun Yang, Jeff Ullman. Oracle Dates and Times. Available at http://infolab.stanford.edu/~ullman/fcdb/oracle/or-time.html.
This page has moved to a new website.