| Sender |
chandrakala
|
| Recipient(s) |
Vivs
|
| Date |
30 Sep 2009
|
Re: Hi
|
Yes you can
>>> On 30 Sep 2009, Vivs wrote:
Can we write a function and pass the date as dynamic
select rtrim(datediff(yy, convert(datetime, '14/05/1984', 103), getdate())) + ' Years ' +
rtrim(datediff(mm, convert(datetime, '14/05/1984, 103), getdate()) - datediff(yy, convert(datetime, '14/05/1984', 103), getdate()) * 12) + ' Months'
|