How to remove time from datetime ?

Question

0.00/5 (No votes)

See more:

Hi ,

In my database I have column of datatype date.

from c# I am doing this , which contains time as well ..

C#

DateTime date = new DateTime(fYear, month, 1)

any way which will removes time and store only dat to sql db ?

What I have tried:

DateTime date = new DateTime(fYear, month, 1).Date;

Posted 3-Mar-16 10:41am

Torakami

Updated 3-Mar-16 16:59pm

Add a Solution

Comments

Patrice T 3-Mar-16 20:10pm

Why is it a problem to use a DateTime type ?

[no name] 3-Mar-16 20:20pm

As ppolymorphe is implying this is not such a good idea because it is error prone and removes the built in usefulness of DateTime. Better to learn how to use DateTime fully.

koolprasad2003 3-Mar-16 23:10pm

.ToString() method will always helpful to you, just pass data format as paramerter,
e.g. DateTime.Now.ToString("M/d/yyyy");
Hope it helps

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)

an0ther1 · Answer 1 · 2016-03-03T13:50:00

Depending on what type of Database you are using you will need to convert the DateTime in C# to a string.
Typically Date values are surrounded by #'s as below;

SQL

#1/1/2000#

The easiest way is to therefore convert the date to a string using

C#

DateTime.ToString("d/M/yyyy");

Take a look at the following MSDN articles;

MSDN - DateTime.ToString(string)[^]

MSDN - Standard Date and TIme Format Strings[^]

MSDN - Custom Date and Time Format Strings[^]

zcf-prince · Answer 2 · 2016-03-03T16:59:00

Solution 2

C#

DateTime db = new DateTime(2016,12,3);

Console.WriteLine(db.ToString("yyyy-MM-dd"));

result: 2016-12-03

Posted 3-Mar-16 16:59pm

zcf-prince