Short datetime in data model class

Question

0.00/5 (No votes)

See more:

Hello, so I have this data model class in my .Net Web API:

C#

public class ExcelReport
  {
      public string ProjectName { get; set; }
      public DateTime CreatedOn { get; set; }
  }

Right now it saves the date to such format in the database: 2020-08-01T00:00:00.

What I want to achieve is getting rid of everything after the date, without changing the data type to string (as this column in the database uses the DATE type, not VARCHAR). Is it possible?

What I have tried:

I have played around with .ToShortDateString method and the like, but don't think it's suited to this particular problem.

Posted 23-Jan-22 4:34am

Member 15341738

Updated 23-Jan-22 5:35am

Add a Solution

Comments

Richard MacCutchan 23-Jan-22 14:12pm

"Right now it saves the date to such format in the database: 2020-08-01T00:00:00."
No it does not. It stores it as a DateTime object, which has no format. It only appears in any particular format when you try to display it.

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)

Dave Kreskowiak · Answer 1 · 2022-01-23T05:35:00

Solution 1

That's stored in an appropriate database type. What you see in the database has nothing at all to do with your code.

If you want to store only the date, you have to change the datatype in the database to 'date'. Read the documentation on SQL Server for date/time datatypes here[^].

Posted 23-Jan-22 5:35am

Dave Kreskowiak