[mysql+javascript] mysql datetime field to javascript - format date (+bootstrap-table)

[Costas]

reference
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Reference/Global_Objects/Date/toLocaleString

mysql yyyy-mm-dd

pure js - no external library required

				function date_formatter(value, row) {
					if (value==null)
						return "";

					var date = new Date(value);
					var options = {
					    year: "numeric", month: "2-digit",
					    day: "2-digit", hour: "2-digit", minute: "2-digit", hour12: false
					};
					
					return(date.toLocaleString("en-GB", options));
				}

using it via bootstap-table

			[TABLE]
 			   data-sort-name="log_UTC_when" data-sort-order="desc"
			   
	           data-side-pagination="server"
	           data-query-params="queryParamsLOGGER">
			   
				[TD]
					[TR]
															<!-- using data-formatter attribute -->
						[TD]
							Date UTC
						[/TD]
					[/TR]
				
			</table	>

locales:

af-ZA
ca-CA
cs-CZ
da-DK
de-CH
de-DE
el-GR
en-GB
en-US
es-AR
es-ES
es-VE
et-EE
fi-FI
fr-FR
he-IL
hu-HU
it-IT
ja-JP
nl-NL
no-NO
pl-PL
pt-BR
pt-PT
ru-RU
sk-SK
sl-SI
sv-SE
tr-TR
uk-UA
zh-CH