Date format for hikashop_order order_created

Hi all
I am trying to pull data via an ODBC connector from Hikashop into MS Access so that I can integrate it with other systems. When I look at order_created in hikashop_order I am seeing values like 1343065635 and 1380810301 which I don't recognise. I need to convert them to a standard dd-mm-yyyy format can you tell me how I can convert the string?

Thanks

Hi,

In HikaShop, the dates are stored in unix timestamp format.
You can use the function hikashop_getDate() for the conversion into string.

Regards,