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 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, 8741👍, 0💬
Popular Posts:
Can you write a program to interchange 2 variables without using the third one? a = 7; b = 2; a = a ...
What are the two fundamental objects in ADO.NET ? Datareader and Dataset are the two fundamental obj...
What Tools to Use to View HTML Documents? The basic tool you need to view HTML documents is any Web ...
How do we get the current culture of the environment in windows and ASP.NET? “CultureInfo.CurrentCul. ..
If we inherit a class do the private variables also get inherited ? Yes, the variables are inherited...