Internal Website Search

> support Support Apparently we found the bug, which affects indexes on pure Date fields (i.e. date with no time). ObjectDB converts pure date values between local time and UTC ... that records are being added to the DB at the time of the time change. However, what values in the date

Hi,  I have to sum to a date of minutes, and check the date obtained is greater than the current date. My idea is as follows: Calendar currentTime = Calendar.getInstance(); Date currenteDate = currentTime.getTime

comparison with java.sql.Date value doesn't match any results in the database. Our code looks like ... = ...; java.sql.Date myDate = ...; Predicate predicate = builder.equal(root.get("eintritt"), builder.literal ... greaterEqual or lessEqual with Criteria API will yield in correct results except if the given date

Hi, For some time now we can use date and time function in queries to extract part of date time (from documentation): YEAR({d '2011-12-31'}) is evaluated to 2011 ... ({t '23:59:00'}) is evaluated to 0. Quite often I have to group by date(). For few queries

Hi, Today I was playing with some date-range queries in explorer ... from TestObject o where o.date > :someDate where o.date is java.util.Date, 'where' doesn't work as it should. Results are not filtered by date. There is no such problem in code

.java.util.Date' was not included in the set of types which can be serialized by ... ganesh gothai The objectdb.java.util.Date class is a subclass of java.util.Date that ObjectDB uses in order to track changes. 

> private Date startDateTime; // Time stamp: start of recording in local time zone private Date startDate; // Date: date part of startDateTime private Date startTime; // Time: time part of startDateTime @Basic(optional = false

Question on dates. SQL doesn't seem to store timezone with dates (oddly). So, any best practises with ODB? 1. use java.util.Date ... > dmoshal David Moshal When a Date instance is stored in an ObjectDB

"> package entity; import java.util.Date; import java.util.List; import javax.persistence ... .DATE)     private Date birthdate;     /**      ... the birthdate      */     public Date getBirthdate() {  

> are not equivalent. Date and Time Literals JPQL follows the syntax of SQL and JDBC for date literals: Date - {d 'yyyy-mm-dd'} - for example: {d '2019-12-31 ... ">literal("JPA"); // Date and Time literals: