data type for showing year in sql server

Question

0.00/5 (No votes)

See more:

SQL-Server

hello friends
i want to store year as 2008-2009. which datatype is better in sql server.

Thank you

Posted 17-Jul-12 7:59am

baskaran chellasamy

Add a Solution

3 solutions

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)

abhinavvijay · Answer 1 · 2012-07-17T08:06:00

Solution 1

the only way to store the value, you have to use varchar,nvarchar (string) data type

Posted 17-Jul-12 8:06am

abhinavvijay

Comments

OriginalGriff 17-Jul-12 14:10pm

Why "only"? there are loads of ways you could store it, starting with "number of years since the year 2008-2009" as a number. All of them are much, much more data friendly (in that you can do better comparisons and maths with them). Storing numbers as strings is a poor idea in nearly every single case.

OriginalGriff · Answer 2 · 2012-07-17T08:07:00

To be honest I would just store the actual date, and just post process it to get the tax year (or whatever period is the year 2008-2009) either in my external code or a stored procedure.

That way, you aren't discarding information you might later want to use if the requirements change slightly. The space difference isn't massive, and storage is pretty cheap.

Sandeep Mewara · Answer 3 · 2012-07-17T08:11:00

Solution 3

store year as 2008-2009
If you want to store it exactly as 2008-2009, then varchar(10) should fit best.

Posted 17-Jul-12 8:11am

Sandeep Mewara