Le 05/01/12 19:26, Jeff Sadowski a écrit :

Hi Jeff,

> Thank you for mentioning datediff
> "SELECT * FROM `modifiedprintusage` where
> DATEDIFF(CURRENT_DATE,`date`)<3 ORDER BY `ip` DESC;"
> works great from the commandline mysql but libreoffice is rejecting it.
> 

It should work with the SQL parser turned off, but this means that you
can't use the graphical query designer, you can only work in SQL mode.

Alex


-- 
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Reply via email to