About MONTH

1-10 of 35Refresh
Manual
100

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
Issue
2

Unexpected Exception (Error 990) with ArrayIndexOutOfBoundsException

a few months ago and did some upgrades to the ObjectDb. I did not delete the Database file during these changes. The system where that error occured was installed a few months ago. So it was not