> I am not familiar with the 'current date' construct in this example: > "from Calendar cal where cal.holidays.maxElement > current date" > > Is 'current' a function? If so, is 'date' the argument? Is this ORACLE > specific?
"current date" would need to be a Hibernate defined token. Oracle uses "sysdate" for the current date/time Postgres uses "now" .... etc, etc, IMHO, I think the token "now" would be good to use, since its a little more intuitive than sysdate or most other timestamp tokens out there. For example, when looking at the tokens "sysdate" or "CURRENT_DATE" does that just mean an SQL date and not a timestamp? In Oracle it doesn't. What about tokens like "CURRENT_TIME"? Does that just mean an SQL time and not a timestamp? Maybe tokens like CURRENT_TIMESTAMP or "now" make more sense for the current system timestamp.... Les ------------------------------------------------------- This SF. Net email is sponsored by: GoToMyPC GoToMyPC is the fast, easy and secure way to access your computer from any Web browser or wireless device. Click here to Try it Free! https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
