is it possible (in sql or php) to order dotted decimal numbers properly. For example: IP address, or software versions.
this is the order you'd want
typical text ordering would produce
date ordering kind of uses the desired ordering principal where you order by the number before the first dash, then by the number before the second dash, etc.