How to convert datetime to database's format

-- HikaShop version -- : 4.0.3

Hello,

I am trying to connect Hikashop (mysql) to 3rd party SaaS software to be able to generate coupons automatically.

Only problem I have is that I would need to convert date time (for example DD/MM/YYYY HH:MM) to format that is stored in Hikashop database: for example: 1455449220

Please, what is the formula? What logic is there?


Thank you very much in advance,
Filip

Hi,

It is a unix timestamp:
www.unixtimestamp.com/
In PHP, you have many functions to handle dates and unix timestamps:
www.php.net/manual/en/function.strtotime.php
www.php.net/manual/en/function.strftime.php

In MySQL, you also have functions to convert them directly in the conditions of the MySQL queries or for the results:
stackoverflow.com/questions/11133760/mys...me-to-unix-timestamp

Thank you very much! That helped a lot!