How to change the date from: Mon Mar 23 13:50:43 2005 to: 03-23-2005 09:50:43 Wed ??? 1. The form as ASTCC stores the date / time does not allow to sort the records (ASC/DESC) by date. I would like to change it to a form that allows me to sort the records. 2. Is there a way to change existing records to the new format too? (Maybe mysqldump => excel (change format) => insert into mysql) or a program? 3. To compare date I need to obey time zones. If I want to compare my records with the gateway I need to change the date. What would be a way how to do that? bye Ronald