title: how to take a date in csv and convert it from european timestamp to the american format in bash?
body: <p>I want to convert the date in the first row of my csv to have the american notation. The best way for me would be to go with the bash. But date doesn't linke my format and my attempt with awk was horrible.</p>
  
  <p>Original CSV:</p>
  
  <pre><code>Datum;Verbrauch
  15.05.2016 00:00;0,075
  15.05.2016 00:15;0,075
  15.05.2016 00:30;0,075
  15.05.2016 00:45;0,075
  15.05.2016 01:00;0,075
  </code></pre>
  
  <p>Wanted CSV:</p>
  
  <pre><code>Datum;Verbrauch
  2016-05-15 00:00:00;0,075
  2016-05-15 00:15:00;0,075
  2016-05-15 00:30:00;0,075
  2016-05-15 00:45:00;0,075
  2016-05-15 01:00:00;0,075
  </code></pre>
  
  <p>thx for your help</p>