Database problem

I added a new attribute called order_date to the jos_hikashop_order table using the DATE format. However when i process an order the date does not seems to work and come out as 0000-00-00 00.00.00 in the database. How to i make it that it will track the time when i process and order and appear in the jos_hikashop_order table under the newly create order_date attribute. Please help THANKS!

Hi , is there any solution to this problem??

You should edit your order_date column and set its default value you "current timestamp" but that will set the date of when the order was created which is already in the order_created field.

the order_created field is not in a date time format, this is what i get from my database. 1321971206. how do i read this information ?

That's a unix timestamp.
If HikaShop is loaded, you can use the function hikashop_getDate() to convert it into a date. That function is implemented in the file administrator/components/com_hikashop/helpers/helper.php