0019611: Some dates always have the month in English

ID	Project	Category	View Status	Date Submitted	Last Update

0019611	phpList 3 application	Internationalization (l18n)	public	05-12-18 21:50	19-07-19 16:45

Reporter	duncanc
Priority	normal	Severity	minor	Reproducibility	sometimes
Status	resolved	Resolution	fixed
Product Version	3.3.6
Target Version	3.3.8	Fixed in Version	3.3.8

Summary	0019611: Some dates always have the month in English
Description	On some pages dates are formatted within a mysql query instead of phplist, which means the month name is in English instead of the admin's selected language. For example the uclicks page has the month of first click translated but the month of the latest click is in English, see screenshot. I think that most of the problem areas can be found by grep'ing for "DATE_FORMAT(", the mysql function to format a date. Then review those and where possible move the date formatting to php code using the functions formatDate() or formatDateTime();
Tags	No tags attached.

duncanc 05-12-18 21:50 updater	date_format.png (14,783 bytes) date_format.png (14,783 bytes)

michiel 05-12-18 21:56 manager ~0061522	Can't that be resolved by localising Mysql instead?

duncanc 06-12-18 10:24 updater ~0061530	From what I can see most dates are formatted with php, it is only a few cases, such as the page I mentioned, that format some dates through mysql.