sql get date format yyyy-MM-dd hh:mm:ss code example

Example 1: javascript format date yyyy-mm-dd hh:mm:ss to dd-mm-yyyy hh:mm am/pm

dateString = '2020-04-03 20:30:55';

function formatDate(dateString)
    {
        var allDate = dateString.split(' ');
        var thisDate = allDate[0].split('-');
        var thisTime = allDate[1].split(':');
        var newDate = [thisDate[2],thisDate[1],thisDate[0] ].join("-");

        var suffix = thisTime[0] >= 12 ? "PM":"AM";
        var hour = thisTime[0] > 12 ? thisTime[0] - 12 : thisTime[0];
        var hour =hour < 10 ? "0" + hour : hour;
        var min = thisTime[1] ;
        var sec = thisTime[2] ;
        var newTime = hour + ':' + min + suffix;

        return newDate + ' ' + newTime;
    }

Example 2: c# datetime dd/mm/yyy hh:mm:ss

DateTime.Now.ToString("dd'/'MM'/'yyyy HH:mm:ss")
 //output: 13/06/2020 13:05:21