problem in saving date in sql from c#

Question

0.00/5 (No votes)

See more:

Hi iam yogesh and i m having problems in date saving in sql table
my code for saving a date is

C#

datetime mdat;
mdat = dtpdate.Value;     //dtpdate is datepicker
insert into saltrn (dat) values(mdat.ToString("dd/MM/yyyy"))
//for eg: when i saved 27-11-2011 in  my table(.entry is saved)..... Now when i am //looking from sql select query, the same entry 
// looks like  1894-07-16 00:00:00.000
//why is it happening?

HELP ME PLEASE .. instead of 27-11-2011, 1894-07-16 00:00:00.000 is getting saved.

Posted 27-Nov-11 5:53am

yogesh a sharma

Updated 27-Nov-11 6:32am

Sander Rossel

v2

Add a Solution

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)

Akos Orban · Answer 1 · 2011-11-27T06:24:00

Solution 1

If you are using a DateTime type in the SQL table, the proper string format to pass would be: YYYY-MM-DD, so 2011-11-27 in your case.

Posted 27-Nov-11 6:24am

Akos Orban

Comments

yogesh a sharma 27-Nov-11 12:37pm

THANKS , but i tried it and still failed
this time i am getting 1905-05-28 00:00:00.000 instead.

Akos Orban 27-Nov-11 12:52pm

Try to add the datetime object as the value to your query, which is inserting the value to the table. If you are using ADO.NET something like this:
SqlCommand command = new SqlCommand("INSERT INTO saltrn (dat) VALUES(@date)", connection);
command.Parameters.Add("@date", SqlDbType.DateTime);
command.Parameters["@date"].Value = dtpdate.Value;
command.ExecuteNonQuery();

Also make sure that dtpdate.Value contains the proper value you want to save. Add a breakpoint at the insert statement, and check the value of it.

yogesh a sharma 27-Nov-11 13:21pm

Thanks sir i got my answer..

RaviRanjanKr 27-Nov-11 13:27pm

5+