How to store only date in datetime

Question

0.00/5 (No votes)

See more:

Hi!
I have a problem in converting the string only to date.
I am getting the date as string from database

ex:

C#

string datestring = "12/10/2012"
Datetime dt = Convert.ToDateTime(datestring);

How to save the string in date field as date, because the previous example is storing the date with time and I don't want the time 00:00:00.

Can you help me please?

Regards,

S. Keshaavan

Posted 2-Feb-12 4:53am

NK7

Updated 2-Feb-12 5:03am

Manfred Rudolf Bihy

v3

Add a Solution

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

Manfred Rudolf Bihy · Answer 1 · 2012-02-02T05:07:00

Solution 2

If you don't want to use the time part of DateTime then just don't.
First read here: String.Format[^]
then go after this: Standard Date and Time Format Strings[^]
after that have some of this: Custom Date and Time Format Strings[^]

Regards,

Manfred

Posted 2-Feb-12 5:07am

Manfred Rudolf Bihy

Paul E Davies · Answer 2 · 2012-02-02T05:10:00

Solution 3

A dateTime value is just that a Date & Time, if no time is supplied then the 00:00:00 are used by default.

You can either just use the date part of your dt object (dt.date I think)or store your return string as a different type to datetime, such as string.

Posted 2-Feb-12 5:10am

Paul E Davies

Wooln · Answer 3 · 2012-02-02T17:56:00

Solution 4

Just ignore the tail of the DateTime, because there is no current appropriate type in .net framework, of cause you can define a new class to implement the function you wanted.

Posted 2-Feb-12 17:56pm

Wooln

sunil gurjar · Answer 4 · 2012-02-02T19:14:00

Solution 5

try this code

C#

string datestring = "12/10/2012";
Datetime dt = Convert.ToDateTime(datestring).Date;

Posted 2-Feb-12 19:14pm

sunil gurjar

khan mohd faizan · Answer 5 · 2012-02-02T19:21:00

Solution 6

string datestring = "12/10/2012"
string date=Convert.ToDateTime(datestring ).ToString("MM/dd/yyyy");

try this code and try to insert into database

definatly it will work

Posted 2-Feb-12 19:21pm

khan mohd faizan

Updated 2-Feb-12 19:31pm

v2

Comments

Rajesh Anuhya 3-Feb-12 1:31am

Edited: Code Tags added.
--RA