[Koha-devel] Using date functions in report SQL

[Nicole Engard]

Michael - Good catch :) I didn't even see the typo :)

---

Nicole C. Engard
Open Source Evangelist, LibLime
(888) Koha ILS (564-2457) ext. 714
nce at 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
<mdhafen at tech.washk12.org> wrote:
> 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
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha.org
> http://lists.koha.org/mailman/listinfo/koha-devel
>