Accurate Search Engine


Tuesday, July 13, 2010

SQL Date Interval

Q: Can I make SQL command to count 100 days after now?

A: Yes You can









THE Time SQL Syntax
NOW()
CURDATE()
CURTIME()
DATE_ADD
INTERVAL


You can see the example below

SELECT CURTIME();
SELECT CURDATE();
SELECT NOW();
SELECT DATE_ADD(CURTIME(),INTERVAL 100 DAY);

OK?
Please try in your SQL Browser or Application Programs

No comments:

Post a Comment