• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 638
  • Last Modified:

how to update/change all created time in jos_content to one same time (joomla)


I want update/change created time for all contents in jos_content table in joomla, I want change all diffirent time to one same time .

The table "created" have format like this: 2004-06-12 11:54:06
I am very newbie with sql systax, please give me a query so I can run in phpmyadmin

thanks alot
  • 2
1 Solution
UmeshMySQL Principle Technical Support EngineerCommented:
Try this..

 You may want to set below variables ...this would be

Pls update below @newcreated variable and set the date which you want... thr is no where clause in it so it would update entire table... if needed take a dump of this table..

SET @newcreated = '2008-11-22 00:02:00';

UPDATE jos_content
   SET created=@newcreated;
UmeshMySQL Principle Technical Support EngineerCommented:
Any updates on this?
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now