This blog is a One Stop source which will help you in your day to day life. From technical help, tips and knowledge sharing.
Keep Blogging...
Wednesday, June 4, 2008
Difference between two dates in T-SQL
for day datediff(days,[column_name1],[column_name2]) for month datediff(monts,[column_name1],[column_name2]) for year datediff(year,[column_name1],[column_name2])