Thursday, August 1, 2013

how to get the no of days between two dates

to get the no of days between two dates,
use the following sql query

SELECT DATEDIFF(DAY,'2013-04-12',GETDATE())

return value : 265

Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)