[Asterisk-Users] ASTCC date format

[Ronald Wiplinger]

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