Julien Anguenot a écrit : > 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 ?
That would be worth adding those as examples in the nuxeo book :) -- Olivier _______________________________________________ ECM mailing list [email protected] http://lists.nuxeo.com/mailman/listinfo/ecm
