[Koha-devel] Using date functions in report SQL

[Michael Hafen]

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 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 Analyst
> PTFS Inc.
> Content Management and Library Solutions
> 6400 Goldsboro Road, Suite 200
> Bethesda, MD  20817
> (301) 654-8088 x 151
> jwagner at ptfs.com
> 
> 
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel
-- 
Michael Hafen
Systems Analyst and Programmer
Washington County School District
Utah, USA

for Koha checkout
http://koha-dev.washk12.org
or
git://koha-dev.washk12.org/koha