display date from database and calculate age

Question

1.00/5 (1 vote)

See more:

hi,

i want to display date(dob) from database to label
i want to display date in label
and also calculate age from date of birth
thanx

Posted 1-Mar-14 9:22am

Manish Dalwadi

Add a Solution

Comments

CHill60 1-Mar-14 15:23pm

Ok ... you can go ahead and do that. Let us know if you hit a problem

Manish Dalwadi 1-Mar-14 15:24pm

my dr. i have no idea for retrive date from database...so i asking you..
important id display date...for me.

JoCodes 2-Mar-14 0:30am

Show some effort from your side then ask if you are stuck somewhere. "No idea for retrieve data from Db" doesnt help you either. A simple search would have made you learn this. And then the calculation part may be you could have asked.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Krunal Rohit · Answer 1 · 2014-03-01T09:27:00

Solution 1

SELECT FLOOR((CAST (GetDate() AS INTEGER) - CAST(Date_of_birth AS INTEGER)) / 365.25) AS Age

Read this thread[^].

-KR

Posted 1-Mar-14 9:27am

Krunal Rohit

Comments

Manish Dalwadi 1-Mar-14 15:28pm

sorry to say but i want sql code my dr.
please help me u can
coz i dont know how to do

Krunal Rohit 1-Mar-14 15:30pm

This is a SQL Query and link also tells the same.

-KR

Manish Dalwadi 1-Mar-14 15:30pm

okay