Home » Search

About DAY

1-10 of 85Refresh
Manual
92

Date and Time in JPQL and Criteria Queries

such functions as an extension. ObjectDB supports 6 functions for extracting the YEAR, MONTH, DAY, HOUR ... '}) is evaluated to 12. DAY({d '2011-12-31'}) is evaluated to 31. HOUR({t '23:59:00'}) is evaluated to 23 ... ); Expression month = cb.function("month", Integer.class, date); Expression day = cb
Manual
16

General Settings and Logging

is empty ("") logging to file is disabled. Every day a new log file is generated with the name odb ... directory. The retain attribute specifies how many days to keep the archived log files
Result
11

Privacy Policy

adverts. Such cookies are used for conversion and referral tracking and typically expire after 30 days
Result
11

ObjectDB License

days of the purchase date, provided that you haven't activated your license. Server License ObjectDB
Forum
5

TemporalType injection with Calendar using JPA

.PersistenceException Unexpected argument (com.foo.bar.jpa.enity.TimePeriod[ day, java.util.GregorianCalendar ... ,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_OF_DAY=19,MINUTE=14,SECOND=43,MILLISECOND=31,ZONE_OFFSET
Forum
3

Grouping by date()

to 12. DAY({d '2011-12-31'}) is evaluated to 31. HOUR({t '23:59:00'}) is evaluated to 23. MINUTE({t ... 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
Forum
2

query on calendar class

where Calendar.DAY_OF_WEEK is FRIDAY or any other. My class: @Entity public class Cdr {     private static ... =em.createQuery("SELECT c FROM Cdr c where c.start.DAY_OF_WEEK = ?1",Cdr.class); query.setParameter ... .persistence.PersistenceException Navigation from 'java.util.Calendar' through 'DAY_OF_WEEK
Issue
2

Server out of memory exceptions

has typically been running for 3-4 days without issue. The stack trace doesn't provide much information. Could you get heap dump snapshots - after one day, two days, three days - in order to detect memory ... . As the real problem only presents itself after a few days the test is deliberately more extreme
Forum
2

Group by date / time

Hi, I'm trying to create reporting query that will return entities grouped by year / mont / day ... DAY() in ODB. So, how to build queries similar to something like this: SELECT COUNT(id) FROM ... these expressions (as an extension to JPA) - support of date/time methods (YEAR, MONTH, DAY, HOUR, MINUTE
Forum
2

Mismatch client-server protocol prefix

the Doctor. It found no errors. We use this method for over 3 years now. It's from the early days of our software when we used MySQL. This method is called thousands of times a day by different daemons ... 256 but its obviously not. Additionally this exception got raised multiple times during the day: com