About MONTH

1-10 of 28Refresh
Manual
90

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 month = cb.function("month", Integer.class, date); Expression day = cb
Forum
6

TemporalType injection with Calendar using JPA

,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_OF_DAY=19,MINUTE=14,SECOND=43,MILLISECOND=31,ZONE_OFFSET ... ,endTimeMode=2]],firstDayOfWeek=2,minimalDaysInFirstWeek=4,ERA=1,YEAR=2011,MONTH=4,WEEK_OF_YEAR=22,WEEK
Forum
3

Getting sales quantity per country with a query, an idea anyone?

of orders, per country, only including valid orders (ord.getPaidTimeD()) and for a given month back in ... ")).getInstance();         Calendar to = (GregorianCalendar) now.clone();         to.add(Calendar.MONTH, monthBack + 1);         to.set(to.get(Calendar.YEAR), to.get(Calendar.MONTH), 1
Forum
3

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 ... these expressions (as an extension to JPA) - support of date/time methods (YEAR, MONTH, DAY, HOUR, MINUTE
Forum
2

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 ... ) - Extracts the date part (year, month, day) as a Date instance. TIME(ts) - Extracts the time part (hour
Issue
2

Database access error , Doctor hanging on trying to repair, production shutdown at our biggest customer

on the last transaction in which it was modified). Is it possible that you had this corruption for 2 months ... months, but it was found only now? > for sure this is possible   hgzwicker
Forum
2

Date field Index is corrupted due to time change

);                 calendar.set(Calendar.YEAR, 1970);         calendar.set(Calendar.MONTH, Calendar.JANUARY);         calendar.set(Calendar.DAY_OF_MONTH, 1);                 return calendar.getTime
Forum
2

java.lang.ClassCastException: CriteriaQueryImpl cannot be cast to java.util.List

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 ... to your original topic from 4 months ago, and therefore should not be discussed in this thread.   ThreaT
Forum
2

Wrong data stored in time only fields

);         calendar.set(Calendar.MONTH, Calendar.JANUARY);         calendar.set(Calendar.DAY_OF_MONTH
Result
1

ObjectDB version 2.2.9

Version 2.2.9 Added new configuration to enable / disable auto serialization of non persistable types (now disabled by default). Added support of date methods (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND). Added support of bypassing no arg constructors of entity classes. Added support of using