Solved

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

Posted on 2008-10-22
4
623 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:
ushastry earned 200 total points
Comment Utility
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:ushastry
Comment Utility
Any updates on this?
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

A lot of articles have been written on splitting mysqldump and grabbing the required tables. A long while back, when Shlomi (http://code.openark.org/blog/mysql/on-restoring-a-single-table-from-mysqldump) had suggested a “sed” way, I actually shell …
All XML, All the Time; More Fun MySQL Tidbits – Dynamically Generate XML via Stored Procedure in MySQL Extensible Markup Language (XML) and database systems, a marriage we are seeing more and more of.  So the topics of parsing and manipulating XM…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now