Hello, tell me, please, how can I get a date with the name of the month in a specific language using a single SQL query? Next command:

Select STNAME, to_char(BIRTHDAY,'DAY MONTH DD, YYYY', 'nls_date_language=russian') As Birthday From user19.Student Where STNAME like '%O_';

tries to display the names of the months in Russian, but there is a problem with the encoding (as a result of the crocodile). How can one team display a date in a specific language? thank

  • name the server. Oracle I think so - renegator
  • Yes, server oraklovy. - tenety 2:21 pm

1 answer 1

Try using the CONVERT () function .
But for this you need to know (determine) the original and required encoding.