Csanyi Pal <csanyipal(at)gmail(dot)com> writes:
> How can I get the day name say 'monday' not in English but in Hungarian?
The documentation for to_char suggests that you need to say "tmday"
not just "day" to get a translated day name. You might also need to
fool with your LC_TIME setting.
regards, tom lane