When formatting dates, months are displayed in Russian and alphabetical order

[Alina_Kobzar]

Hello!
I have a problem that when I do formatting:

format(as.Date('2019-04-09', '%Y-%m-%d'), '%B')

I receive this:
[1] "апрель"

How can I change language for Date?
I’d really appreciate your help

[FJCC]

I think you need to change the LC_TIME component of you locale. You can see how the locale is set with Sys.getlocale(). I use Windows 10 in the United States and I get the following. Notice LC_TIME=English_United States.utf8 at the end of the output.

Sys.getlocale()
[1] "LC_COLLATE=English_United States.utf8;LC_CTYPE=English_United States.utf8;LC_MONETARY=English_United States.utf8;LC_NUMERIC=C;LC_TIME=English_United States.utf8"

What you should set LC_TIME to depends on your operating system. You can try

Sys.setlocale(category = "LC_TIME", "English")

[Alina_Kobzar]

Thank you for your response. Tell me please, if I have geolocation in Ukraine, will it work?

[FJCC]

Sorry, I'm not sure what you mean. In what language do you want the result to be? What is your operating system? What is the result of

Sys.getlocale()

[Alina_Kobzar]

@FJCC

Sys.getlocale()

[1] "LC_COLLATE=Russian_Ukraine.utf8;LC_CTYPE=Russian_Ukraine.utf8;LC_MONETARY=Russian_Ukraine.utf8;LC_NUMERIC=C;LC_TIME=Russian_Ukraine.utf8"

[FJCC]

@FJCC

In what language do you want the result to be? What is your operating system?

What about my two other questions?

[Alina_Kobzar]

I want that Date would be in English.
OS: Microsoft Windows 11 Pro

[FJCC]

Yes, I think running

Sys.setlocale(category = "LC_TIME", "English")

will work for you. It solved a similar problem in this thread:

convert lubridate::date to a formated date

I am running Windows 11. I got it by changing only I have changed the Sys.setlocale("LC_TIME", "English") This is what I get now: library (lubridate) #> #> Attaching package: 'lubridate' #> The following objects are masked from 'package:base': #> #> date, intersect, setdiff, union time1<- lubridate::date () time2<-as.POSIXct (time1, format="%a %b %d %H:%M:%S %Y") timestamp <- lubridate::round_date(time2, unit = "5 minutes") strftime(timestamp, format = "%A %d-%m-%Y; %H:%M") #> [1] "Monday 18-03-2024; 16:50" Many thanks!

That user had LC_TIME=Spanish_Spain.utf8 but I doubt that difference matters.

[Alina_Kobzar]

Thank you for your attention and help ))