About CURRENT_DATE

31-40 of 200Refresh
Forum
8

Entity Update - Is the documentation up to date?

is always expected to be up to date with the last ObjectDB version. > First, I've been modifying managed entities ... , because an object is identified as dirty by comparing its old content with the current content ... with the field's current value, I can test for equality inside the setter, like this: public void setFoo(int
Forum
8

Problem with 'where' and date()

Hi, Today I was playing with some date-range queries in explorer and found a small problem. When you try to use queries like this: SELECT o 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
Forum
8

GWT RPC is throwing serialization exception when I have object db date value

Caused by: com.google.gwt.user.client.rpc.SerializationException: Type 'objectdb.java.util.Date ... .java.util.Date class is a subclass of java.util.Date that ObjectDB uses in order to track changes. It implements java.io.Serializable but probably this is not sufficient for GWT because Date is a special
Forum
7

Wrong data stored in date only fileds

Hi, we have an object with the following fields:   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
Forum
7

Dates

Question on dates. SQL doesn't seem to store timezone with dates (oddly). So, any best practises with ODB? 1. use java.util.Date 2. Milliseconds since January 1, 1970, 00:00:00 GMT 3. other? When a Date instance is stored in an ObjectDB database it is converted automatically to GMT, so in
Forum
7

Entity with java.util.Date column gives ClassCastException in BIRT

JPQL query to select the fields. Entity looks like this: package entity; import java.util.Date ... ="birthdate")     @Temporal(value = TemporalType.DATE)     private Date birthdate ... the birthdate      */     public Date getBirthdate() {         return birthdate
Forum
7

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 something like this: SELECT COUNT(id) FROM stats WHERE YEAR(record_date) = 2009 GROUP BY DATE
Issue
7

Bug when using SIZE in combination with date lower parameter

there seems to be a bug if I use the lower date select: SELECT j.jobId, SIZE(j.tags) FROM ParserJob j WHERE j.dateCreated < :date This returns a SIZE(j.tags) of 0 Tags, but the only existing ParserJob has 1 Tag. If I run the query: SELECT j.jobId, SIZE(j.tags) FROM ParserJob j WHERE j.dateCreated >= :date I
Forum
7

Order in WHERE Clause affects behaviour on DATE/DATETIME columns

; @Temporal(TemporalType.TIMESTAMP) @Column(name = "myDate") Date myDate; } Now ... would get an IllegalArgumentException: Parameter value [%myQuery%] did not match expected type [java.util.Date (n/a)] because I ... of the WHERE clauses obviously makes a difference. The date column seems to be converted to a String
Forum
7

Using date in where clause

-2013" Here I have created Persons object as java.sql.Date attribute.   But in doing so I am getting ... with date in where clause. The query is invalid because you compare a date (the creationDate field) with a string literal ("07-25-2013"). Replace the string with a date literal or a parameter. n126961