With MS SQL server you can do something like this: select convert(char(10), expiration, 101) as <something> ... order by convert(varchar, expiration, 112)
112 gives the date format as "yyyymmdd", and that should solve your problem. -----Original Message----- From: Harpreet K. Singh To: 'Php-Windows ' Sent: 23-3-2004 19:06 Subject: [PHP-WIN] Convert string to date I have a report that has an expiration field I want to sort by expiration but when clicked it sorts alphanumerically and shows january 01 before march 03 no matter what the year. If i do select expiration and sort it works fine but if i say select [expiration]=convert(char(10), expiration, 101) it sorts alpha numerically. I want to display in the format above but sort by date Please help -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
