Tutorials
Resources
Forum
Communities
Interview
Jobs
Projects
Offshore Development
Silverlight Tutorials
|
Mentor
|
Code Converter
|
Articles
|
Code Factory
|
Computer Jokes
|
Members
|
Peer Appraisal
|
IT Companies
|
Bookmarks
|
Revenue Sharing
|
Prizes & Awards
My Profile
Sign In
Register
AdSense Revenue
Active Members
Today
Abhi
(65)
Appukuttan
(40)
raj krishna
(37)
Last 7 Days
Appukuttan
(660)
Babu Akkandi
(465)
Tejinder Singh ...
(273)
more...
New Feature:
Community Sites
:
Create your own .NET community website and start earning from Google AdSense !
It's Free !
caluclate age in years
Posted Date: 30 Jun 2008
Resource Type:
Code Snippets
Category:
SQL
Author:
Kapil Dhawan
Member Level:
Gold
Rating:
Points
: 5
declare @dob datetime,
@age int,
@day datetime
set @day = '2008-06-30'
set @dob = '1980-10-27'
set @age = datediff(yy,@dob,@day)
select @age
Responses
No responses found. Be the first to respond and make money from
revenue sharing program
.
Feedbacks
Popular Tags
What are tags ?
Search Tags
Sign In
(No tags found.)
Post Feedback
This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must
Sign In
to post a response.
Next Resource:
How to insert values from existing table into new table with same table structure?
Previous Resource:
Sqlserver 2005 Date format
Return to Discussion Resource Index
Post New Resource
Category:
SQL
Post resources and
earn money
!
Related Resources
Stored procedure with use of Cursor
Instead Of Trigger Example
Run-Time Calculation Column in SQL Server
Stored Procedure with IF else loop
working with SELECT
dotNet Slackers
BizTalk Adaptors
Web Design
Contact Us
Privacy Policy
Terms Of Use