comment on

Do I have to convert this column before the ST to a number,

A number or a string, it makes little difference

and after the ST convert it back to the DD-MM-YYYY format?

No, you just throw the sortable number/string away. Something like this:

print for map  { $_->[0] }             # extract original date
          sort { $a->[1] cmp $b->[1] } # Sort, using sortable date
          map  {
              m/(\d\d)-(\d\d)-(\d{4})/;
              [$_, "$3$2$1"]           # [original date, sortable date
+]
          } <DATA>;

__DATA__
02-02-2007
01-01-2006
03-03-2009
02-02-2009
[download]

Output:

01-01-2006
02-02-2007
02-02-2009
03-03-2009
[download]

Unless I state otherwise, all my code runs with strict and warnings

In reply to Re: Sorting dates with the Schwartzian Transform by FunkyMonk
in thread Sorting dates with the Schwartzian Transform by Wobbel

Are you posting in the right place? Check out Where do I post X? to know for sure.
Posts may use any of the Perl Monks Approved HTML tags. Currently these include the following:
<code> <a> <b> <big> <blockquote> <br /> <dd> <dl> <dt> <em> <font> <h1> <h2> <h3> <h4> <h5> <h6> <hr /> <i> <li> <nbsp> <ol> <p> <small> <strike> <strong> <sub> <sup> <table> <td> <th> <tr> <tt> <u> <ul>
Snippets of code should be wrapped in <code> tags not <pre> tags. In fact, <pre> tags should generally be avoided. If they must be used, extreme care should be taken to ensure that their contents do not have long lines (<70 chars), in order to prevent horizontal scrolling (and possible janitor intervention).
Want more info? How to link or How to display code and escape characters are good places to start.


Clear questions and runnable code get the best and fastest answer
	PerlMonks