The ISO SQL standard supports a datatype called "interval". It should be reasonably easy to abstract that in DBMSs that do not support that (f.ex. "TIME" in MySQL).
I personally would like to make use of it, as I use Postgres in the majority of my projects which supports the interval-type. However, SQLObject does not support it. So for now I use a simple IntCol which stores the amount of seconds.... works but is less expressive. Just a thought. It's nothing of major importance for me ;) But I suppose it would be a nice move if SQLObject supported all datatypes as defined in the ISO standard ;) And I think this is the only one that's missing ;) ------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ sqlobject-discuss mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
