store only date in database not time portion C#

Question

I have a test class and an ExecutionDate property which stores only date but when we use [DataType(DataType.Date)] that also stores the time portion in database but I want only date portion.

public class Test
{
     [Key]
     public int Id { get; set; }

     [DataType(DataType.Date)]
     public DateTime ExecutionDate { get; set; }      
}

Is any way to store only date on time portion in db using Entity Framework? Please help me....

I have added snapshot when use [DataType(DataType.Date)] that stores time portion 00:00 I want remove that

Well, what is the **datatype** of the column in your database table?? If the column in your database is `DATETIME` - then of course you get date & time stored. The **database column** must be of datatype `DATE` - not just your attribute on the C# class! — marc_s, Nov 17 '15 at 16:44
Thats more a viewing problem then a storing problem. A datetime is a datetime even if the time portion is set to nothing. Your tool that is showing the content of the table just shows the default format for datetime. If you don't want to see the timepart change the setting of the tool used for viewing db content. — Ralf, Nov 17 '15 at 16:46
You can only make it `DATE` on the database level - in .NET and Entity Framework, we don't have a specific "date-only" datatype. In .NET code, you *always* have date&time - can't change that. But in the SQL Server database table, you can make it a `DATE` and store the date only — marc_s, Nov 17 '15 at 16:48
How your database is created ? If you follow Code First and generate your database from your code then you must add Column(TypeName="date") attribute on that property. — CodeNotFound, Nov 17 '15 at 19:46

score 61 · Accepted Answer · answered Nov 19 '15 at 13:28

I think you are trying to specify database column type. You could use data annotations as described in this article.

Here is an example :

[Table("People")]
public class Person
{
    public int Id { get; set; }

    [Column(TypeName = "varchar")]
    public string Name { get; set; }

    [Column(TypeName="date")]
    public DateTime DOB { get; set; }
}

By default, string is translated to nvarchar, we have changed that here. Also Datetime (this is what you asked I suppose) which by default maps to datatime in sql server, is changed to date which stores only the date portion and not the time portion of a DateTime value.

Lapenkov Vladimir · Answer 2 · 2020-03-23T06:27:05.663

4

On EF core one may add override OnModelCreating in DbContext class.

protected override void OnModelCreating(ModelBuilder builder)
        {
            builder.Entity<Test>().
                Property(p => p.ExecutionDate)
                .HasColumnType("date");
        }

edited Mar 23 '20 at 06:27

answered Mar 23 '20 at 05:24

Lapenkov Vladimir

3,066
5
26
37

Is this tied to a specific DB engine? – Guillermo Prandi Jul 31 '20 at 14:53

score 1 · Answer 3 · answered Nov 17 '15 at 18:05

As David said above, once you bring that data into the application it will be a DateTime with the timestamp added onto the date. This would be the same result too if you stored the date as a string and used Convert to change to a DateTime for any manipulation:

string date = "2015-11-17";
var dateTime = Convert.ToDateTime(date);

Unless you want to manipulate strings in your application to avoid the timestamp, you can only work with DateTime. For display purposes though, you can always format the date and remove the timestamp:

var dateTime = DateTime.Now;
var formatDate = dateTime.ToString("yyyy-MM-dd");

score 1 · Answer 4 · answered Nov 15 '21 at 20:06

1

In .NET 6 now you have new special type - DateOnly

More info here: https://github.com/dotnet/efcore/issues/24507 https://www.stevejgordon.co.uk/using-dateonly-and-timeonly-in-dotnet-6

answered Nov 15 '21 at 20:06

Mateusz D

338
1
2
9

score -2 · Answer 5 · edited Nov 17 '15 at 20:00

-2

Change datatype on the database from Datetime to Date type

Is it really an issue for you anyway? You may want time in there at some point,

edited Nov 17 '15 at 20:00

CodeNotFound

22,153
10
68
69

answered Nov 17 '15 at 16:54

Mark Homer

960
6
15

3

Any particular reason to downvote? HE want store DATE ONLY in database and there is a DATE type which does exactly that lol – Mark Homer Nov 28 '18 at 13:18

score -3 · Answer 6 · answered Nov 18 '15 at 12:17

-3

Change DateTime to nvarchar(10) in database if u use DateTime in database 00.00.00 will be automatically assigned by database

string date = DateTime.Today.ToShortDateString();

answered Nov 18 '15 at 12:17

Krishna shidnekoppa

1,011
13
20

store only date in database not time portion C#

6 Answers6

Linked