suppose my store date is 05/10/2005 and current date 04/10/2012.........so i want to get only year difference 7.
year diff
how get year difference from store date to current date???
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
VulpesPosted Oct 4, 2012, 8:18 AM
Rewant ChoudharyPosted Oct 4, 2012, 8:03 AM
SELECT DATEDIFF(year, '2005-12-31 23:59:59.9999999'
, '2006-01-01 00:00:00.0000000');