39 | Date and Time in JPQL and Criteria Queries 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 ... ); Expression<Integer> month = cb.function("month", Integer.class, date); Expression<Integer> day = cb |
39 | TemporalType injection with Calendar using JPA,endDayOfWeek=1,endTime=3600000,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 ... ]],firstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=1,YEAR=2011,MONTH=4,WEEK_OF_YEAR=22,WEEK_OF_MONTH=5,DAY_OF_MONTH |
22 | Getting sales quantity per country with a query, an idea anyone?.getPaidTimeD()) and for a given month back in time. The resulting Object list contains the 3 SELECT ... .MONTH, monthBack + 1); to.set(to.get(Calendar.YEAR), to.get(Calendar.MONTH), 1); if (to.after(now)) {to = now;} Calendar from = (GregorianCalendar) now.clone(); from.add(Calendar.MONTH, monthBack); from |
19 | Group by date / time. 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 ... (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND) was just added to ObjectDB in build 2.2.8_02. For example |
17 | Grouping by date() (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 ... in queries: DATE(ts) - Extracts the date part (year, month, day) as a Date instance. TIME(ts |
17 | ObjectDB and Spring Boot - sharing a simple working example Person p WHERE MONTH(p.birthDate) = :month") List<Person> findAllByBirthDateMonth(int month |
14 | General Performance Issues Illustrated with a Specific Method."); } else if (getAgeYears() > 0) { setAge(period.getYears() + " years and " + period.getMonths() + " months."); } else { setAge(period.getMonths() + " months and " + period.getDays |
14 | Date field Index is corrupted due to time change); calendar.set(Calendar.MONTH, Calendar.JANUARY); calendar.set(Calendar.DAY_OF_MONTH, 1 |
14 | java.lang.ClassCastException: CriteriaQueryImpl cannot be cast to java.util.ListPlease follow the posting instructions and use a separate thread for each subject. Your new question is not related to your original topic from 4 months ago, and therefore should not be discussed in ... for each subject. Your new question is not related to your original topic from 4 months ago, and therefore should not be discussed in this thread. support Support |
2 | Unexpected Exception (Error 990) with ArrayIndexOutOfBoundsException itself, am I right? We upgraded from JDK 1.8 to 11 a few months ago and did some upgrades ... was installed a few months ago. So it was not affected by every change I just mentioned. However 2.7 |
