skip to main
|
skip to sidebar
Pages
Home
About Me
Technical Dreams...
Ads 468x60px
Social Icons
Thursday, 27 October 2011
Age Calculation
Hi,
In most of the project we need to calculate the age.
Consider below TSQL to calculate age, it should be used where age needs to be displayed.
SELECT
CAST
((
DATEDIFF
(
dd
,
<date_of_birth>
,
GETDATE
())/
365.25
)
AS
INT
)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Social Icons
Powered by
Blogger
.
Popular Posts
Followers
Archive
►
2015
(5)
►
September
(1)
►
August
(1)
►
April
(1)
►
March
(2)
►
2014
(18)
►
December
(1)
►
November
(1)
►
September
(2)
►
July
(2)
►
May
(5)
►
March
(1)
►
February
(3)
►
January
(3)
►
2013
(15)
►
December
(1)
►
November
(1)
►
October
(1)
►
June
(1)
►
May
(1)
►
March
(1)
►
February
(2)
►
January
(7)
►
2012
(40)
►
December
(6)
►
November
(2)
►
October
(8)
►
September
(4)
►
May
(6)
►
April
(5)
►
March
(5)
►
February
(3)
►
January
(1)
▼
2011
(27)
►
December
(4)
►
November
(15)
▼
October
(8)
Age Calculation
Calendar In Sql Server Reporting Services.
Split the comma separated value
Comma separated Value In SQL-Server
JQuery Date Function
Case Statement in INNER JOIN
SSRS Column header is not repeating???
Unique constraint to allow multiple NULL's in Sql ...
Search
No comments:
Post a Comment