[Israel.pm] Sorting By MySQL DATETIME Fields?

Yuval Yaari yuval at windax.com
Wed Jun 16 03:40:46 PDT 2004


On Wed, 2004-06-16 at 12:49, Jorge Grippo wrote:
> Hi Yuval
> 
> Prepare your queries with date_format to return the dates in the format:
> YYYYMMDD
> After that you can use 'sort' to sort them.
> 
> Jorge

I also need it to sort by hour, minute, and a lot of times even second.

Maybe if I s/[-:\s]//; I could <=> it (thanks Gaal)...


  --Yuval




More information about the Perl mailing list