Please support our MS SQL advertiser: Programming Forums
Views: 4101 | Replies: 5 | Solved
 |
•
•
•
•
| |
•
•
Join Date: Jul 2005
Posts: 4
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
I need a help.
I have a SQL SERVER database where I have put persons with their birthdate. I need to calculate ages of them. For examble my birthdate is 12/27/1982 and I have to debit (minus) from current date.
Does anyone have any idea how to solve this problem.
I have a SQL SERVER database where I have put persons with their birthdate. I need to calculate ages of them. For examble my birthdate is 12/27/1982 and I have to debit (minus) from current date.
Does anyone have any idea how to solve this problem.
•
•
Join Date: Feb 2003
Location: Canada
Posts: 786
Reputation:
Rep Power: 9
Solved Threads: 25
Master Poster
Use the SQL DATEDIFF function.
DATEDIFF( datapart, date_expression1, date_expression2)
i.e.
Hope that helps
Happy coding
DATEDIFF( datapart, date_expression1, date_expression2)
i.e.
DATEDIFF (year, '1/1/1999', '1/1/2000') would give 1 as a result
Hope that helps
Happy coding
Assistant Manager, Regional Pharmacy Information Systems
TLC Services Website (Under Construction)
Updated : ASP.Net Login Code
TLC Services Website (Under Construction)
Updated : ASP.Net Login Code
•
•
Join Date: May 2005
Location: London, UK
Posts: 145
Reputation:
Rep Power: 0
Solved Threads: 1
Junior Poster
Sounds tricky! Maybe you could adapt a javascript to suit your needs?
•
•
Join Date: Feb 2003
Location: Canada
Posts: 786
Reputation:
Rep Power: 9
Solved Threads: 25
Master Poster
Tricky?
And what does Javascript have to do with SQL functions?
The function is simple.... how is it tricky?
And what does Javascript have to do with SQL functions?
The function is simple.... how is it tricky?
•
•
•
•
Originally Posted by Electrohead04
Sounds tricky! Maybe you could adapt a javascript to suit your needs?
Assistant Manager, Regional Pharmacy Information Systems
TLC Services Website (Under Construction)
Updated : ASP.Net Login Code
TLC Services Website (Under Construction)
Updated : ASP.Net Login Code
•
•
Join Date: Jul 2005
Posts: 4
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
I still get error on calculation, but it is syntax error.
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'year'.
Where could be the problem.
Server: Msg 170, Level 15, State 1, Line 1
Line 1: Incorrect syntax near 'year'.
Where could be the problem.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Hybrid Mode