Home » Search

About CURRENT_DATE

31-40 of 200Refresh
Forum
8

Grouping by date()

Hi, For some time now we can use date and time function in queries to extract part of date time ... have to group by date(). For few queries I was concatenating 'date' from year()-month()-day() calls ... to add one more method to above list - date() - that will return only date from java.util.Date field
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
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

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