Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

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

Posted on 2008-10-22
4
Medium Priority
?
635 Views
Last Modified: 2013-11-05
Hello

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
0
Comment
Question by:t2hol
  • 2
4 Comments
 
LVL 26

Accepted Solution

by:
Umesh earned 800 total points
ID: 22783274
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;
0
 
LVL 26

Expert Comment

by:Umesh
ID: 22937461
Any updates on this?
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
In this blog, we’ll look at how improvements to Percona XtraDB Cluster improved IST performance.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question