Solved

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

Posted on 2008-10-22
4
627 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
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:ushastry
ID: 22937461
Any updates on this?
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Foreword In the years since this article was written, numerous hacking attacks have targeted password-protected web sites.  The storage of client passwords has become a subject of much discussion, some of it useful and some of it misguided.  Of cou…
Fore-Foreword Today (2016) Maxmind has a new approach to the distribution of its data sets.  This article may be obsolete.  Instead of using the examples here, have a look at the MaxMind API (https://www.maxmind.com/en/geolite2-developer-package). …
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

776 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