How do I solve this line?

Question

1.00/5 (1 vote)

See more:

C#

dateFrom = Convert.ToDateTime(dr["DateFrom"].ToString());

How do I retrieve as Date only?

Posted 30-Jan-14 23:58pm

Member 10548723

Updated 1-Feb-14 19:33pm

agent_kruger

v5

Add a Solution

Comments

Karthik_Mahalingam 31-Jan-14 6:01am

what issue you are facing >?

Member 10548723 31-Jan-14 6:01am

When I retrieve from database, is datetime when I stored it as Date.

Pete O'Hanlon 31-Jan-14 6:06am

Please stop raising the same question over and over again. Engage in a discussion with the people who have already answered your questions in other threads if you have a problem. As it stands, people will soon start deleting your duplicate questions.

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)

Matt T Heffron · Answer 1 · 2014-01-31T08:00:00

Solution 2

So, the problem is with formatting the DateTime?
Just specify the format string explicitly when converting to a string using .ToString:

C#

string formattedDate = Convert.ToDateTime(dr["DateForm"].ToString()).ToString("dd/MM/yyyy");

Posted 31-Jan-14 8:00am

Matt T Heffron

Updated 1-Feb-14 19:35pm

v2

Karthik_Mahalingam · Answer 2 · 2014-01-31T17:34:00

See , if your SQL Column DataType is Date it will store as "01/01/2001" (time stamp will not be included)
if it is DateTime it will include Date and Time values...

in C#
we dont have a Date DataType, we have only DateTime which is a combination of Date and Time
You can get the Date Value in string format only not the DateTime Object.

use SOlutoin 1 for Getting in string format.
and your code for actual DateTime.

Hope you understood.
come back if you need more clarification.

_________
Karthik

Fredrik Bornander · Answer 3 · 2014-01-31T00:01:00

Solution 1

Try

dateForm = Convert.ToDateTime(dr["DateForm"]).Date;

Hope this helps,
Fredrik

Posted 31-Jan-14 0:01am

Fredrik Bornander

Comments

Member 10548723 31-Jan-14 6:04am

Didn't work.

Fredrik Bornander 31-Jan-14 6:09am

What happened?

Member 10548723 31-Jan-14 6:12am

Still is being retrieve as datetime i am not sure what is the error

Fredrik Bornander 31-Jan-14 6:14am

What do you mean by Date then? Do you not want this as an instance of the type DateTime?

Member 10548723 31-Jan-14 7:05am

For example 31/1/2014 not this 31/1/2014 12.00AM

Member 10548723 31-Jan-14 7:06am

Your code is working but there's an mistake.

I want the date as dd/MM/yyyy
example: 31/01/2014

Now is 31/Jan/2014