My HQL needs to compare the dateselect a.id.applicationno, b.id.applicPcodefrom dirHibernate.AccountApplic ation as b,dirHibernate.AccountDtl as pwhere b.id.Flag = 'Y'and b.id.applicationDate is not nulland b.id.applicationDate =:FromDate Tue Aug 01 00:00:00 EST 2006and b.id.applicationDate = Tue Aug 01 00:00:00 EST 2006and b.id.applicationDate. Try String queryString ='select ' + ' a.id.applicationno ' + ', b.id.applicPcode ' +' from BpApplication b' + ',BpPlanApplic p' +' where b.id.planFlag = 'Y' ' +' and b.id.FromDate = ':FromDate +' and b.id.ToDate devjdbc:oracle:th in:@137.1.:devorg.hiberna te.dialect.OracleDia lect.
The last version of the JPA specification (which is 2.1) was released before Java 8, and as a result, it cannot handle the new Date and Time API.
Standard Date and Time Format Strings. 28 minutes to read.In this articleA standard date and time format string uses a single format specifier to define the text representation of a date and time value. Any date and time format string that contains more than one character, including white space, is interpreted as a custom date and time format string; for more information, see. A standard or custom format string can be used in two ways:.To define the string that results from a formatting operation.To define the text representation of a date and time value that can be converted to a or value by a parsing operation.