How to format a date field into diferente languages in the same command? (multiple locales)

The following will return the day in Italian: SET lc_time_names = 'it_IT'; select date_format('2018/01/01','%W') as day_italian; However I need to convert or format the date into multiple languages, so it would return me another column in English, Japanese, so on... My problem is that I have to set the locale BEFORE running the select command.