ANSI Date Type in latest Ingres Release
There was a new date type introduced in Ingres 2006 update release 2 that brings Ingres date types into alignment with the ANSI standard. As noted in a previous blog entry, you can definitely search our docs to get all the info you need, but I also found this nice hands on blog entry.