This post talks a little bit about DATE and TIMESTAMP in Oracle and some oftheir pitfalls. TL;DR: Representing dates and timestamps correctly is a very hardproblem (required viewing). Table of Contents Intro DATEs Plain TIMESTAMPs TIMESTAMP WITH LOCAL TIME ZONE TIMESTAMP WITH TIME ZONE Conclusion Using Oracle DATEs in Java Sources Intro When I was tasked with putting some data in BigQuery, Google Cloud’sdata warehouse implementation, I had to look at the data we currentlystore in our local ...
