Retrive birthdate form table

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

I have table MemberInfo(

DOB varchar (20)

)

it store birthdate in dd-MMMM formate i.e. 17-July

pls help me to find upconig birthdate

Posted 18-Jul-12 2:24am

Nandkumar Sharma

Add a Solution

Comments

StianSandberg 18-Jul-12 8:36am

You really should keep dates as date. Your column should be a DateTime datatype. Now you will have to first convert the varchar and then query for dates upcoming.

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)

Vasim889 · Accepted Answer · 2012-07-18T02:35:00

Solution 1

SQL

select convert(varchar(15),birthdate ,106) from you table name

Posted 18-Jul-12 2:35am

Vasim889

Comments

Nandkumar Sharma 18-Jul-12 9:02am

hi thanks for reply i had did it bu it show error
Conversion failed when converting datetime from character string.
bcoz of dob stored in "18-July" format not year included

Vasim889 19-Jul-12 0:51am

you will try this one.http://www.sqlusa.com/bestpractices/datetimeconversion/