I didn't see the typo either, and I was looking right at a MySQL book when I
copied the function. Thanks -- I'll give that a try.
Jane Wagner
Library Systems Analyst
PTFS Inc.
Content Management and Library Solutions
6400 Goldsboro Road, Suite 200
Bethesda, MD 20817
(301) 654-8088 x 151
jwag...
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
Does anyone have some examples of using date functions like currdate()
and month() in report SQL statements? Is this possible in Koha reports?
I'm not having any luck -- even a very simple
select currdate()
report comes back with a generic error message.
Thanks.
Jane Wagner
Library Systems Ana
