oracle dates and times   (link)

http://www-db.stanford.edu/~ullman/fcdb/oracle/or-time.html
date- and time-related oracle syntax reference