order_created int(10) , not date

  • Posts: 1057
  • Thank you received: 11
  • Hikashop Business
8 years 11 months ago #222908

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?

Please Log in or Create an account to join the conversation.

  • Posts: 26158
  • Thank you received: 4028
  • MODERATOR
8 years 11 months ago #222916

Hi,

It is timestamp.

Regards,


Jerome - Obsidev.com
HikaMarket & HikaSerial developer / HikaShop core dev team.

Also helping the HikaShop support team when having some time or couldn't sleep.
By the way, do not send me private message, use the "contact us" form instead.

Please Log in or Create an account to join the conversation.

  • Posts: 1057
  • Thank you received: 11
  • Hikashop Business
8 years 11 months ago #223114

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

Please Log in or Create an account to join the conversation.

  • Posts: 82868
  • Thank you received: 13378
  • MODERATOR
8 years 11 months ago #223117

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

Please Log in or Create an account to join the conversation.

  • Posts: 2143
  • Thank you received: 747
8 years 11 months ago #223139

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


Need help with customisations of layouts, style or other site development? PM me!
(Don't forget to turn on "E-mail notification of new messages" )

Please Log in or Create an account to join the conversation.

Time to create page: 0.083 seconds
Powered by Kunena Forum