Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
How To Increment Dates by 1
How To Increment Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling
✍: FYIcenter.com
If you have a date, and you want to increment it by 1 day, you can use the DATE_ADD(date, INTERVAL 1 DAY) function. You can also use the date interval add operation as "date + INTERVAL 1 DAY". The tutorial exercise below gives you some good examples:
SELECT DATE_ADD(DATE('1997-01-31'), INTERVAL 1 DAY) FROM DUAL; 1997-02-01 SELECT DATE('1997-01-31') + INTERVAL 1 DAY FROM DUAL; 1997-02-01
2007-05-11, 6140👍, 0💬
Popular Posts:
The object that contains all the properties and methods for every ASP.NET page, that is built is .. ...
If XML does not have closing tag will it work? No, every tag in XML which is opened should have a cl...
Describe in detail Basic of SAO architecture of Remoting? For these types of questions interviewer e...
Can an anonymous class be declared as implementing an interface and extending a class? An anonymous ...
What is the difference between mysql_fetch_object() and mysql_fetch_array() functions in PHP? mysql_...