BigMemory 4.3.9 | Product Documentation | BigMemory Max Developer Guide | Searching with BigMemory SQL | SQL Syntax and Examples | Dates
 
Dates
BigMemory SQL can parse two date types:
*the java.util.Date cast by the date keyword
*its subclass, java.sql.Date, which is cast using the sqldate keyword
BigMemory SQL can parse the following common formats of date and time strings:
'yyyy-MM-ddTHH:mm:ss.SSS z'
'yyyy-MM-ddTHH:mm:ss.SSS'
'yyyy-MM-ddTHH:mm:ss z'
'yyyy-MM-ddTHH:mm:ss'
'yyyy-MM-ddz'
'yyyy-MM-dd'
Formats which are supported by ISO 8601 but not by BigMemory SQL are:
*DD omission (YYYY-MM)
*Week Date formats (YYYY-Www-D)
*Ordinal dates (YYYY-DDD)
*Durations (e.g., P3Y6M4DT12H30M5S)
*Time intervals (e.g., 2007-03-01T13:00:00Z/2008-05-11T15:30:00Z)
Examples of Dates
select * from Person where dateOfBirth = (date)'2012-12-01T10:10:20'
select * from Person where dateOfBirth = (date)'2012-12-01'
select * from Person where dateOfBirth = (date)'2012-12-01T10:22'
select * from Person where dateOfBirth = (date)'2012-12-01T10:10:22.433 EST'