Sergey Zhemzhitskiy wrote: > Can anybody help me? I need to insert date into the nxql. > For example > select * from Document where dc:created >= '12.10.2005 14:51'. > How to do that?
Some example :
On dates :
SELECT * FROM Document WHERE bk:published >= DATE '2007-04-01'
On timestamp and date :
SELECT * FROM Document WHERE bk:published BETWEEN TIMESTAMP '2007-03-03
02:00' AND DATE '2007-04-03'
Do you need more information ?
J.
--
Julien Anguenot | Nuxeo R&D (Paris, France)
Open Source ECM - http://www.nuxeo.com
Nuxeo 5 : http://www.nuxeo.org
Mobile: +33 (0) 6 72 57 57 66
signature.asc
Description: OpenPGP digital signature
_______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm
