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/>
This whole thing is very sloppy. You don't need to use as much code as you have to accomplish the simple task you're attempting.

Try something like this:

```
$("li").on("click", ".remove", function(){
    var $this = $(this),
        liCont = $this.closest("p"),
        parentLi = $this.closest("li");
    liCont
        .clone()
        .wrap(
            $("<div>").addClass("no-display")
        )
        .appendTo("body");
    parentLi.remove();
});

```

What we do here is capture the click event on any `.remove` elements. We select the parent `p` (which we later clone to wrap with a `div`) as well as the parent `li`. We clone the `p` element (including its contents), wrap it with a `div` element (which we create using DOM scripting and add the class), and append the finished product to the body (you can change that if needed). We then remove the original `li`.