Question: I have a column in which it stores date value. However, some how the dates were populated in the wrong format. The date format of the column is `DD/MM/YYYY`, however the date was populated as `MM/DD/YYYY`. How can I change the value from `MM/DD/YYYY` to `DD/MM/YYYY`? E.g. At this moment, it is showing `03/05/2012` and it is read as `3rd May 2012` whereby it really should really have been populated as `05/03/2012` (`5th March 2012`).

The above has been solved, but I have a similar question:
How can I flip "2012-12-01 12:33:00.0" to become "2012-01-12 12:33:00.0"? I had tried "select convert(varchar(50), convert(datetime, log\_date, 103), 121)" and used both 101 and 103 and still not able to flip it.

Answer: 
A little optimized: <http://jsfiddle.net/hKUd6/>
Something like this:

```
$('.remove').live('click',function(){
    var pLi = $(this).closest('li');
    s = $('<div>').append(pLi.clone().addClass('no-display')).html();
    pLi.remove();
    console.log(s);
});

```