[Zope-dev] I'm having troubles with MySQL MONTHNAME() function
Andres Sanchez Gomez
locolive@arnet.com.ar
Fri, 27 Oct 2000 17:53:42 -0300
Hello:
I'm from Argentina, as you shoud now, I speak spanish. I'm usig MySQL,
as you sould also now, it's in English.
I have to give de time informatio in letters. Like 'Febrero' (02,
February).
I found two ways, but non of them gives me good results.
The first way is to ask to the database a select statemment with it's
own MONTHNAME() functio. But I couldn't translate to Spanish that is
what I need.
The other way is to make a little function that compares the month
number (selected with te MONTH() function). In this case I had the same
trouble:
I can't compare a DateTime MySQL function var with an other var.
I can't do this:
<dtml-if " Month(DATE)==' 1' >Diciembre
<dtml-elif " Month(DATE)==' 2' >Febrero
etc....
Thanks to anyone who can help me, or read me.
And please, forget my english.
Andres Sanchez Gomez