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 Calculate the Difference between Two Dates
How To Calculate the Difference between Two Dates? - MySQL FAQs - Introduction to SQL Date and Time Handling
✍: FYIcenter.com
If you have two dates, and you want to know how many days between them, you can use the DATEDIFF(date1, date2) function as shown below:
SELECT DATEDIFF(DATE('1997-02-28'), DATE('1997-03-01')) FROM DUAL; -1
2007-05-11, 5186👍, 0💬
Popular Posts:
How many bits are used to represent Unicode, ASCII, UTF-16, and UTF-8 characters? Unicode requires 1...
What's difference between HashTable and ArrayList ? You can access array using INDEX value of array,...
Can one execute dynamic SQL from Forms? Yes, use the FORMS_DDL built-in or call the DBMS_SQL databas...
Rachel opened her math book and found that the sum of the facing pages was 245. What pages did she o...
Which bit wise operator is suitable for turning on a particular bit in a number? The bitwise OR oper...