Need help to SQL change the Product Add Date

[explorer1979]

Hi all,

My shop have add some new products, but the Products Date Add timestamp is wrong, for example 2023-08-28 12:35:55 etc on the MySQL.....

I have phpmyadmin...

How to enter SQL command there, search all the miss date, then change to sometime timestamp like that 2012-08-28 etc?

Thank you.

[FeriSK]

1. backup database !!!
2. Go Tools/Install SQL Patches
3. UPDATE products SET products_date_added = CURRENT_TIMESTAMP WHERE products_date_added > CURRENT_TIMESTAMP;

[explorer1979]

Hi FeriSK,

Thank you very much. It work for me