order_created int(10) , not date

Hi!
We re creating some scripts to make hikashop fully compatible with a delphi software.
We are in the orders table and the programmer is asking to have the order_created from int(10) to date, so that he can import this into his system.

If I change it manually from phpmyadmin is it ok? If not, can you help us with a script or direction on how to convert int to date?

Hi,

It is timestamp.

Regards,

The delphinet programmer needs time like 13/12/2015 15:15
is it possible to give an idea?

Hi,

It sure is possible. I suppose that your programmer must know about the FROM_UNIXTIME function of MySQL which allows you to convert a timestamp in a date and in that function, you can specify the format that you want for the date:
dev.mysql.com/doc/refman/5.5/en/date-and...nction_from-unixtime

If he's a programmer, you'd expect he's heard of it. Otherwise here's a classic reference: php.net/manual/en/datetime.settimestamp.php