 93 | such functions as an extension. ObjectDB supports 6 functions for extracting the YEAR, MONTH, DAY, HOUR, MINUTE and SECOND. For example: YEAR({d '2011-12-31'}) is evaluated to 2011. MONTH({d '2011-12-31 ... that extract date parts:
Expression year = cb.function("year", Integer.class, date |
11 | to this Agreement will bring a legal action under this Agreement more than one year after the cause of action arose |
11 | a result of years of R&D). Outperforms competing products. Connection Pooling Automatic connection pool |
4 | ,ERA=1,YEAR=2011,MONTH=4,WEEK_OF_YEAR=22,WEEK_OF_MONTH=5,DAY_OF_MONTH=30,DAY_OF_YEAR=150,DAY_OF_WEEK=2 ... ,endTimeMode=2]],firstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=1,YEAR=2011,MONTH=4,WEEK_OF_YEAR=22,WEEK_OF_MONTH=5,DAY_OF_MONTH=30,DAY_OF_YEAR=150,DAY_OF_WEEK=2,DAY_OF_WEEK_IN_MONTH=5,AM_PM=1,HOUR=7,HOUR |
3 | Hi, I'm trying to create reporting query that will return entities grouped by year / mont / day. Each entity has it's own field that holds java.lang.Date. There is no function like YEAR(), MONTH() or ... stats
WHERE YEAR(record_date) = 2009
GROUP BY YEAR(record_date), MONTH(record_date) or maybe |
2 | for books for JDO and only found 3, and they are 13 years old and don't cover annotations. Is JDO ... was more capable than JDO's. JPA turned out to be the right choice for me. I have about 10 years ... several years with Objectdb. I have also spent many, many hours over many years comparing DBMS products going |
2 | am perplexed as I have use JPA and ObjectDB for years now. I could use your assistance in overcoming ... . The stack trace is produced by ObjectDB 2.3.7, which is 2 years old now, and many issues have been fixed in the last 2 years. Please try switching to the last ObjectDB version. It is also recommended |
2 | (from documentation): YEAR({d '2011-12-31'}) is evaluated to 2011. MONTH({d '2011-12-31'}) is evaluated ... have to group by date(). For few queries I was concatenating 'date' from year()-month()-day() calls ... ) - Extracts the date part (year, month, day) as a Date instance. TIME(ts) - Extracts the time part (hour |
2 | again. Since your system ran with ObjectDB for a long time (I think 2 years?) without these issues ... data. Rolling back to 2.3.x would be a problem because development work I did this year relies ... count" report (issue #556) was fixed 2 years ago. Possibly this is another bug that produces |
2 | of an object database in a university course on database technology. Last year we used odb104fe, and I ... Object databases for many years who are being lost due to a lack of JDO documentation. 1) makes ... best and excellent solution to my persistence needs for at least the next five years. geekox86 carr.onstott FredrikB AlphaOne |