x 151
jwag...@ptfs.com
-Original Message-
From: Nicole Engard [mailto:nicole.eng...@liblime.com]
Sent: Wednesday, February 25, 2009 10:57 AM
To: Michael Hafen
Cc: Wagner, Jane; koha-devel@lists.koha.org
Subject: Re: [Koha-devel] Using date functions in report SQL
Michael - Good catch :
Michael - Good catch :) I didn't even see the typo :)
---
Nicole C. Engard
Open Source Evangelist, LibLime
(888) Koha ILS (564-2457) ext. 714
n...@liblime.com
AIM/Y!/Skype: nengard
http://liblime.com
http://blogs.liblime.com/open-sesame/
On Wed, Feb 25, 2009 at 10:55 AM, Michael Hafen
wrote:
I haven't tried CURRDATE() - but I have used other date functions successfully:
SELECT issues.date_due FROM issues WHERE issues.date_due <
DATE_SUB(now(), INTERVAL 12 DAY) AND issues.returndate is NULL
I've also used MONTH() and YEAR() successfully.
Hope that helps.
---
Nicole C. Engard
Open S
CURRDATE() isn't a function in MySQL. Have a look here:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
CURDATE() ( with one r ) will work, I tried it.
Good luck.
On Wed, 2009-02-25 at 10:46 -0500, Wagner, Jane wrote:
> Does anyone have some examples of using date functions
