Title: Time Format in Database
Last modified: November 2, 2022

---

# Time Format in Database

 *  Resolved [Md Fathi Rahman](https://wordpress.org/support/users/fathi1999/)
 * (@fathi1999)
 * [3 years, 5 months ago](https://wordpress.org/support/topic/time-format-in-database/)
 * Hi,
    In MySQL database
 * `SELECT * FROM test.wp_c84s672ma8_ac_abandoned_cart_history_lite;`
 * returns a column named `abandoned_cart_time` as in today’s date it’s showing 
   this ‘1667399558’ & this value’1667401742′.
 * In which format it is storing time format in Database?

Viewing 1 replies (of 1 total)

 *  Plugin Support [priyankajagtap](https://wordpress.org/support/users/priyankajagtap/)
 * (@priyankajagtap)
 * [3 years, 4 months ago](https://wordpress.org/support/topic/time-format-in-database/#post-16199101)
 * Hi [@fathi1999](https://wordpress.org/support/users/fathi1999/),
 * This column contains the UNIX timestamp of the date and time on which the cart
   was abandoned.
 * Do let us know if you will have any further queries.
 * Regards,
    Priyanka

Viewing 1 replies (of 1 total)

The topic ‘Time Format in Database’ is closed to new replies.

 * ![](https://ps.w.org/woocommerce-abandoned-cart/assets/icon-256x256.png?rev=2369396)
 * [Abandoned Cart Lite for WooCommerce](https://wordpress.org/plugins/woocommerce-abandoned-cart/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/woocommerce-abandoned-cart/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/woocommerce-abandoned-cart/)
 * [Active Topics](https://wordpress.org/support/plugin/woocommerce-abandoned-cart/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/woocommerce-abandoned-cart/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/woocommerce-abandoned-cart/reviews/)

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [time](https://wordpress.org/support/topic-tag/time/)

 * 1 reply
 * 2 participants
 * Last reply from: [priyankajagtap](https://wordpress.org/support/users/priyankajagtap/)
 * Last activity: [3 years, 4 months ago](https://wordpress.org/support/topic/time-format-in-database/#post-16199101)
 * Status: resolved