About YEAR

1-10 of 66Refresh
Manual
19

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
9

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
9

ObjectDB Object Database Features [2018-01-27]

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

ObjectDB Object Database Features [2018-10-27]

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

ObjectDB Object Database Features

a result of years of R&D). Outperforms competing products. Connection Pooling Automatic connection pool
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
1

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