DB2 SQL date and time cheat sheet

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.  


The perfect gadget

If you could just carry one gadget with you what would it be? Maybe an iPod? How about a Pocket PC or Palm PDA? Cell phone? Digital camera? Video camera? Gameboy? USB thumb drive? Laptop/notebook computer? Arrgh! Stop. Think about it for a minute. Some of us have all of these gadgets and I know some people would like to just be able to carry one device that is a jack-of-all-trades. Here’s a list of what I’d want in such a device.

  • Fully functional PDA organizer running Mac OS X pocket edition. 😉
  • Stylus or mini keypad input a la Palm Treo 600.
  • 480×640 display resolution packed in a frame measuring only 4.4 x 2.4 x 0.7 inches.
  • GSM/GPRS world capable mobile phone.
  • Wi-fi, bluetooth, and GPS receiver built-in.
  • 3 megapixel digital camera with 3x zoom and all the features of a standalone.
  • Ability to record MPEG4/divx videos at 640×480 with digital camera.
  • iPod player application. Capable of playing MP3, AAC, WAV, AIFF, and even WMA files.
  • Tivo-like video recorder/player application.
  • 40 GB internal storage to store all the photos, videos, and music.
  • Audio in/out, video in/out, USB2/Firewire built-in to docking/charging station.
  • USB2 cable adapter to allow the device to function as a USB thumb drive.
  • Lithium-ion battery that lasts a full day on a single charge.
  • SDIO slot for expansion cards.
  • Easy to use.

I think that if such a device was to exist, it would probably cost $1500. Hey Steve jobs! Maybe, Apple Computer Inc. could step in and use their industrial design expertise to design such a device. Just a thought.


Apple’s Software Design Guidelines

I came across a very interesting page discussing design guidelines for Apple software. It may be of interesting reading for other platforms and developers wanting to improve the experience for software and web users. Here’s a sample outline.
Human Interface Design

  • Human interface design principles
  • Keep your users in mind
  • Extending the interface

Attributes of Effective Design

  • High performance
  • Easy to use
  • Attractive appearance
  • Reliability
  • Adaptability
  • Interoperability
  • Mobility

Personally, I think that Apple’s software and website are very well designed and easy to use. They continue to set the standards for the industry to follow.