Solved

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

Posted on 2008-10-22
4
630 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 26

Accepted Solution

by:
Umesh earned 200 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Michael from AdRem Software outlines event notifications and Automatic Corrective Actions in network monitoring. Automatic Corrective Actions are scripts, which can automatically run upon discovery of a certain undesirable condition in your network.…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

624 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