Viewing 7 posts - 46 through 52 (of 52 total)
Hi,
you can try this
select EMP_CODE,DATE_OF_BIRTH ,DATEDIFF(DD,DATE_OF_BIRTH,getdate())/365 as years,(DATEDIFF(DD,DATE_OF_BIRTH,getdate())%365)/30 as months,
DATEDIFF(DD,DATE_OF_BIRTH,getdate())%365%30 as days
from EMP_MST where accountid=4
Hitendra
May 11, 2009 at 1:16 am
Hi,
you can try this
select EMP_CODE,DATE_OF_BIRTH ,DATEDIFF(DD,DATE_OF_BIRTH,getdate())/365 as years,(DATEDIFF(DD,DATE_OF_BIRTH,getdate())%365)/30 as months,
DATEDIFF(DD,DATE_OF_BIRTH,getdate())%365%30 as days
from EMP_MST where accountid=4
Hitendra
May 11, 2009 at 1:16 am
Hello david,
I would like you to elaborate on that. Do you have 0.0000 valued
entry in your money column? Are you trying select ... where money_column>0...
April 29, 2009 at 11:14 pm
Hello david,
I would like you to elaborate on that. Do you have 0.0000 valued
entry in your money column? Are you trying select ... where money_column>0...
April 29, 2009 at 11:14 pm
Hello david,
I would like you to elaborate on that. Do you have 0.0000 valued
entry in your money column? Are you trying select ... where money_column>0...
April 29, 2009 at 11:14 pm
Hello david,
I would like you to elaborate on that. Do you have 0.0000 valued
entry in your money column? Are you trying select ... where money_column>0...
April 29, 2009 at 11:14 pm
Hello david,
I would like you to elaborate on that. Do you have 0.0000 valued
entry in your money column? Are you trying select ... where money_column>0...
April 29, 2009 at 11:14 pm
Viewing 7 posts - 46 through 52 (of 52 total)