Time Format in Database

  • Resolved Md Fathi Rahman

    (@fathi1999)


    3 years, 5 months ago

    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

    (@priyankajagtap)

    3 years, 4 months ago

    Hi @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.