Feb
12

Simple mysql date diff function

admin programming 2012-02-12

sameple 1: select * from table where datediff(createdate, NOW())=’0′;”);

sameple 2: select * from table where createdate>subDate(NOW(), ‘1’);

 

reference: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

,
Address: http://kinghei.com/2012/02/12/simple-mysql-date-diff-function/
«
»
Trackback

no comment untill now

Sorry, comments closed.