How to interpret the date fields in database?

  • Posts: 62
  • Thank you received: 0
13 years 1 month ago #31961

How do you interpret the integer value in the order_created field that is in the jos_hikashop_order table?

We are using this value in an ODBC connection and can't figure out how to interpret this field as a valid date.

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

  • Posts: 83103
  • Thank you received: 13413
  • MODERATOR
13 years 1 month ago #31972

That's a unix timestamp: en.wikipedia.org/wiki/Unix_time

You can easily convert it to a date using the date() function of PHP: php.net/manual/en/function.date.php
or the hikashop_getDate() function which handles automatically the timezones based on your joomla settings.

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

Time to create page: 0.059 seconds
Powered by Kunena Forum