I haven’t had much time lately to write up any articles, but I’ve finally found something that may be useful for those of us who work quite a lot with SQL on the DB2 platform. We don’t need to write up a Java program everytime we want to query for information based on specific time intervals. We can just use the date/time functions built-in to DB2 SQL to manipulate and query the database. More.
For the life of me, I can’t remember where I found this cheat sheet. I apologize in advance for not being able to give out the reference.