• View
• Edit
• History
• Print

OQL DATE function

Syntax:

Returns a porcupine.utils.date.Date object, from an ISO6801? formatted string. Usefull for comparing dates and datetime datatypes. A sample query would be:

select id, modified from deep('/')
where modified between date('2005-06-17T00:00:00')
and date('2005-06-18T00:00:00')
order by modified desc