Date in my language

Hi db developers!

I don´t know if this is possible, but anyway........... i will ask!

if i send this query:

select DATE_FORMAT(now(), '%D %M')

it returns:

28th February

and that´s date in english .

Is it possible to return in another language, for example: in portuguese??

That´s all!

i think this depends on regional settings,
Server Issue the data as it is, and it appears as your computer read the date.

try make the data in your control panel to appear in other language ...

well I don´t think is related with the server settings

I have my windows, regional settings, keyboard and so on in portuguese.

Have a look at this link, maybe u can find something interesting
http://www.mysql.com/doc/en/Date_and_time_functions.html

Any other ideias?

I don'ty know about mysql bout I know how to do it in php. This code works for me:

<?php
setlocale(LC_ALL, 'ro_RO');
echo strftime("%A %e %B %Y", mktime(0, 0, 0, 12, 22, 1978));
?>

it outputs "Vineri 22 Decembrie 1978" which is romanian for "Friday 22 December 1978"

try 'pt_PT' instead of 'ro_RO' for portuguese, and get only the timestamp from the db

Yes I know too.

But I prefer doing it from the 'source', because this makes difference in the speed

any other ideia?

What i´m actually trying to do is to get a column (Type: Datetime) formatted in my native language

got it?