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, 8856👍, 0💬
Popular Posts:
Can we have shared events ? Yes, you can have shared event’s note only shared methods can raise shar...
How To Retrieve Input Values for Checkboxes Properly? - PHP Script Tips - Processing Web Forms If mu...
What is the concept of XPOINTER? XPOINTER is used to locate data within XML document. XPOINTER can p...
Can each Java object keep track of all the threads that want to exclusively access to it?
Can two catch blocks be executed? No, once the proper catch section is executed the control goes fin...