I just learned about the OVERLAPS keyword, used like this: matt=# select (TIMESTAMP '2008-07-24 03:00:00', TIMESTAMP '2008-07-24 09:00:00') overlaps (TIMESTAMP '2008-07-24 5:0:0', TIMESTAMP '2008-07-24 11:0:0') ; overlaps ---------- t (1 row)
I'm testing if the time interval from 3 AM today through 9 AM today overlaps the time interval from 5 AM through 11 AM. How can I use this with SQLObject? I poked around a little with SQLOp. Before I write an ugly patch, is there already a way to do it? It is important to use the TIMESTAMP label to disambiguate types. Matt ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ sqlobject-discuss mailing list sqlobject-discuss@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
