To increase dates in database table run following query and change INTERVAL value to desired value.
UPDATE `table_name` SET `date` = DATE_ADD(`date` , INTERVAL 365 DAY);
MySQL add days to a date in database table
Bookmark and Share
Posted on 3 February 2012
Tags: dates, increase date, sql, update date
About the Author
- How to get name of current Joomla template?
- How to delete and moderate comments in Facebook comments box plugin?
- How to install a new language in Joomla 1.5 websites
- Installing Joomla via SSH
- Log an entry into Joomla Log
- Auto Loading classes in Joomla
- Custom parameter optgroup for Joomla 1.5
- Using JTable class in a front end extension
- Loading a module in a component output
- Retrieving Joomla 1.5 Component, Module, Plugin and Template Parameters
- Sandy: Thanks! This was getting so irritating!! Netbeans would recognize half of my ctp files but not all.. very strange. Thanks again....
- joomlamonster: you said install via ssh, you did not install over ssh, you still used a browser to install. This article should be called how to upload joomla via s...
- hassan: thanks Tahir your answer was great...
- Thorsten Biedenkapp: Thanks for your solution! Worked like a charm! Did you also find a solution to remove / disable modal.css?...
- grumbly: These are generally comfortable hints that i will ever try outside, I am thankful I came across the item. Appreciate it....
- jayendra: Thanks to share this. Nice tutorial....
appache
classes
code
command
command line
component
component parameters
configuration
CSS
curl
database
developers
Eclipse
extension
extensions
function
global
google
Joomla! 1.5
joomla 1.5
md5
module
modules
parameter
parameters
permissions
php
php ini
plugin
plugins
position
reference
reset
settings
sql
ssh
subversion
SVN
tags
template
time
Ubuntu
variable
variables
xml
Search the Site:
Twitter Updates
Copyright © 2013 KA's Blog. All rights reserved.
Proudly powered by WordPress 
Written by khawaib
Topics: SQL