File Library


An Oracle Geek's Guide to Successful Dating
Topic: Developer's Toolkit
Owner: Sean Stuber
Date: 2013-05-17
Subtopic: Tips and Techniques

A humorous but serious look at Oracle's DATE, TIMESTAMP and INTERVAL types. In particular, focusing on the common misuse, alternate best practices and techniques for generating date ranges, filling in missing dates within existing data, manipulating timezones and Daylight Saving Time and exposing some quirks of manipulating the data types including illegal-yet-valid dates and indexing.


Download File   Oracles Geeks Guide to Successful Dating.pptx
Download File   Stuber_Paper.doc
Download File   sstuber.OracleGeeks.pdf
Download File   PAPERsstuber.OracleGeeks.pdf

Become a member of ODTUG to gain access to more than 12,500 files in our technical database.

  • Not a member? Click through to the topic of interest to browse a list of available presentations.
  • Already a member? Log-in here to access the full database


Click here to see the Full Techincal Resource Database