How to create SQL Table with date column ?

Question

1.00/5 (1 vote)

See more:

Hi Team,

Please help me in creating SQL Table with date as column header. Like shown below.

Sno Name 1-06-2013 2-06-2013 3-06-2013 and so on. for entire month.

Thanks in advance

Posted 5-Jun-13 15:43pm

Member 9989624

Add a Solution

Comments

chaau 5-Jun-13 21:52pm

Are you sure this is what you want. It is a very bad design. You will be better off if you put all the dates in a column and have a value associated with the date put in another column. You can always run PIVOT queries against the table to achieve the result in the desired format

_Damian S_ 5-Jun-13 22:37pm

You should put this as a solution so I can award you some points. ;-)

chaau 5-Jun-13 22:41pm

That is fine. (whispering) The true solution would be to tell the OP about the square brackets

Member 9989624 8-Jun-13 1:06am

awarding points for wrong answer is not a good thing.

Member 9989624 8-Jun-13 1:05am

this isn't a bad design.

2 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)

SLNS001 · Answer 1 · 2013-06-05T19:41:00

Solution 1

You may create like this

CREATE TABLE TableName
(
Sno int,
Name varchar(20),
"1-06-2013" datetime,
"2-06-2013" datetime,
"3-06-2013" datetime,
....
)

Happy Coding :)

Posted 5-Jun-13 19:41pm

SLNS001

Comments

Member 9989624 8-Jun-13 1:04am

This s a manual way of adding date as field. If i want to retrieve the values of current date how to do it?

Maciej Los · Answer 2 · 2013-06-05T19:47:00

Solution 2

Have a look here: http://msdn.microsoft.com/en-us/library/ms174979.aspx[^]

SQL

CREATE TABLE Table1
(
    ID INT IDENTITY(1,1)
    MyDate DATETIME
)

More about Data Types (T-SQL)[^]

Posted 5-Jun-13 19:47pm

Maciej Los