39 | 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 | ,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 | .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 | . 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 | (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 | Person p WHERE MONTH(p.birthDate) = :month") List<Person> findAllByBirthDateMonth(int month |
14 | ."); } else if (getAgeYears() > 0) { setAge(period.getYears() + " years and " + period.getMonths() + " months."); } else { setAge(period.getMonths() + " months and " + period.getDays |
14 | ); calendar.set(Calendar.MONTH, Calendar.JANUARY); calendar.set(Calendar.DAY_OF_MONTH, 1 |
14 | Please 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 | 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 |