Zen Cart Logo
Forums / General Questions / Need help to SQL change the Product Add Date

Need help to SQL change the Product Add Date

Views: 851

Results 1 to 3 of 3
31 Aug 2012, 3:06 AM
#1
explorer1979 avatar

explorer1979

Inactive

Join Date:
Jan 2007
Posts:
377
Plugin Contributions:
0

Need help to SQL change the Product Add Date

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.

31 Aug 2012, 1:21 PM
#2
ferisk avatar

ferisk

New Zenner

Join Date:
Sep 2011
Location:
Slovakia
Posts:
11
Plugin Contributions:
0

Re: Need help to SQL change the Product Add Date

  1. backup database !!!
  2. Go Tools/Install SQL Patches
  3. UPDATE products SET products_date_added = CURRENT_TIMESTAMP WHERE products_date_added > CURRENT_TIMESTAMP;
    :smile:
1 Sep 2012, 2:22 PM
#3
explorer1979 avatar

explorer1979

Inactive

Join Date:
Jan 2007
Posts:
377
Plugin Contributions:
0

Re: Need help to SQL change the Product Add Date

Hi FeriSK,

Thank you very much. It work for me