•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MS SQL section within the Web Development category of DaniWeb, a massive community of 392,060 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 4,240 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MS SQL advertiser:
Views: 3903 | 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: 26
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: 26
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)
•
•
•
•
•
•
•
•
DaniWeb MS SQL Marketplace
Linear Mode
- calculate image property in javascript (JavaScript / DHTML / AJAX)
- Factorial Calculate (VB.NET)
- calculate the grades for a student using if..else statements. (Java)
- Calculate the factorial of a number (Visual Basic 4 / 5 / 6)
Other Threads in the MS SQL Forum
- Previous Thread: Select records from different data source
- Next Thread: Need suggestion to select application language
