title: Converting string with multiple dates into a dd-mm-YYYY format
body: <p>I have a DB table with relation 1: N where <code>N</code> represents multiple dates for one event. The column with the dates is <code>DateTime</code> type, and I would like to keep the <code>Time</code> option for later use, but it won't be so bad if I have to change it to <code>Date</code> type.</p>
  <p>The problem comes when I have to show those multiple dates in some <code>GUI</code>. I get the dates with the <code>GROUP_CONCAT</code> function which means that in JavaScript I operate with a string with comma-separated values representing the different dates, which by now is in the default SQL <code>DateTime</code> format - <code>YYYY-mm-dd hh:mm:ss</code>.</p>
  <p>I use the <code>split(',')</code> function to get each date-time value and what I can do is to change the type of the SQL column to <code>Date</code> so when I split the string in JavaScript to end up with <code>YYYY-mm-dd</code> values. Which should be reversed to <code>dd-mm-YYYY</code> for the <code>GUI</code>.</p>
  <p>I'm not sure how to proceed here. I have in mind two main options:</p>
  <p>First: Maybe there's a way to use <code>dd-mm-YYYY</code> format in SQL which will solve all the problems.</p>
  <p>Second: some kind of (complex?!?) String manipulation in JavaScript to split the string of dates into an array with multiple elements and then try to format each element the way I need.</p>
  <p>Honestly - I want to avoid the second option, but don't know if the first is possible, and maybe, there's another way that I haven't think of.</p>