The wrong language when extracting date from datetime using as.Date function

Question

I extract date using this piece of code : all_trips$day_of_week <- format(as.Date(all_trips$date), "%A")

I get days of the week in Russian language (I'm using Windows 10 and it's also in Russian),but I'd like to get them in English since everything else in my R environment is set to English.

I tried this : Sys.setlocale("LC_TIME", "English") it didn't help

Session info:
R version 4.1.2 (2021-11-01)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 10 x64 (build 22518)

Matrix products: default

locale:
[1] LC_COLLATE=Russian_Russia.1251  LC_CTYPE=Russian_Russia.1251   
[3] LC_MONETARY=Russian_Russia.1251 LC_NUMERIC=C                   
[5] LC_TIME=Russian_Russia.1251    

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

loaded via a namespace (and not attached):
[1] compiler_4.1.2 tools_4.1.2

score 2 · Answer 1 · answered Dec 13 '21 at 19:21

2

I found one solution

 Sys.setlocale(category = "LC_ALL", locale = "English")

it does the trick,but it resets back to my system language once I restart R session.

Now I'm wondering how to stop my locale settings from resetting everytime I restart the session.

answered Dec 13 '21 at 19:21

Mohmad

31
4

I found the solution [here](https://stackoverflow.com/questions/67804569/change-system-locale-permanently) – Mohmad Dec 14 '21 at 21:32

score 1 · Answer 2 · answered Dec 13 '21 at 19:07

I couldn't use Sys.setlocale on windows, too.

Found an alternative that works quite good (just replace Sys.time() with your date column):

c("Sunday", "Monday", "Tuesday", "Wednesday", "Thursday", 
  "Friday", "Saturday")[as.POSIXlt(Sys.time())$wday + 1]

Output:

[1] "Monday"

The wrong language when extracting date from datetime using as.Date function

2 Answers2