Home » Search

About YEAR

1-10 of 61Refresh
Manual
85

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 ... that extract date parts:   Expression year = cb.function("year", Integer.class, date
Result
10

Eclipse Public License - v 1.0

to this Agreement will bring a legal action under this Agreement more than one year after the cause of action arose
Result
10

ObjectDB Object Database Features

and algorithms (as a result of years of R&D). Outperforms competing products. Connection Pooling
Forum
3

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 ... ,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
Forum
2

Group by date / time

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

Should I use ObjectDB and JDO?

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
Forum
1

Failed to read the value of field using reflection (error 363)

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
Forum
1

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
1

Negative snapshot user count exception

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

ObjectDB 2 JDO Manual

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