Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Decrement Dates by 1
How To Decrement Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling
✍: FYIcenter.com
If you have a date, and you want to decrement it by 1 day, you can use the DATE_SUB(date, INTERVAL 1 DAY) function. You can also use the date interval subtraction operation as "date - INTERVAL 1 DAY". The tutorial exercise below gives you some good examples:
SELECT DATE_SUB(DATE('1997-03-01'), INTERVAL 1 DAY) FROM DUAL; 1997-02-28 SELECT DATE('1997-01-31') - INTERVAL 1 DAY FROM DUAL; 1997-02-28
2007-05-11, 8981👍, 0💬
Popular Posts:
What is Windows DNA architecture? Note :- If you have worked with classic ASP this question can come...
How can method defined in multiple base classes with same name be invoked from derived class simulta...
What is synchronization and why is it important? With respect to multithreading, synchronization is ...
.NET INTERVIEW QUESTIONS - Where do you specify session state mode in ASP.NET ? The following code e...
What is difference between SITP and UTP in testing ? UTP (Unit Test Plan) are done at smallest unit ...