CODEWITHSUNDEEP
c#datetime
im useless
im useless

Reputation: 7461

How to remove time portion of date in C# in DateTime object only?

I need to remove time portion of date time or probably have the date in following format in object form not in the form of string.

06/26/2009 00:00:00:000

I can not use any string conversion methods as I need the date in object form.

I tried first converting the DateTime to a string, remove the time specific date from it, but it adds 12:00:00 AM as soon as I convert it back to DateTime object back again.

Upvotes: 624

Views: 1315506

Answers (30)

L01NL
L01NL

Reputation: 1813

Since .NET 6 you can do this:

var dateOnly = DateOnly.FromDateTime(dateTime);

Upvotes: 14

Surendra Mishra
Surendra Mishra

Reputation: 11

When comparing/searching Use .Date on both side. For example:

return await _context.KWhLog.Where(e => e.DateAndTime.Date == 
                                                (shortDateValue.Date)).ToListAsync();

The time parameter will be ignored.

Upvotes: 1

Adriano Silva
Adriano Silva

Reputation: 2576

Use the method ToShortDateString. See the documentation http://msdn.microsoft.com/en-us/library/system.datetime.toshortdatestring.aspx

var dateTimeNow = DateTime.Now; // Return 00/00/0000 00:00:00
var dateOnlyString = dateTimeNow.ToShortDateString(); //Return 00/00/0000

Upvotes: 144

balintn
balintn

Reputation: 1453

You can use a Date library like https://www.nuget.org/packages/Date/ to work with Date values, convert them to and from DateTimes, etc.

Disclaimer I'm the author of the above package.

Upvotes: 0

Naveed Hematmal
Naveed Hematmal

Reputation: 383

Add Date property to the DateTime variable

var dateTime = DateTime.Now
var onlyDate = dateTime.Date

Or You can use DataType annotation as well.

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

The DataType annotation is inside the System.ComponentModel.DataAnnotations namespace.

Upvotes: 7

VikciaR
VikciaR

Reputation: 3412

DateTime.Date 

var newDate = DateTime.Now; //newDate.Date property is date portion of DateTime

Upvotes: 12

0x49D1
0x49D1

Reputation: 8704

You can use format strings to give the output string the format you like. 

DateTime dateAndTime = DateTime.Now;
Console.WriteLine(dateAndTime.ToString("dd/MM/yyyy")); // Will give you smth like 25/05/2011

Read more about Custom date and time format strings.

Upvotes: 222

Kovalenko Ihor
Kovalenko Ihor

Reputation: 111

In case you would want to use Binding and show only Date portion without time

ToolTip="{Binding TransactionModel.TransactionDate, StringFormat=d}"

Upvotes: 0

nate.py
nate.py

Reputation: 21

To get only the date portion use the ToString() method,

example: DateTime.Now.Date.ToString("dd/MM/yyyy")

Note: The mm in the dd/MM/yyyy format must be capitalized

Upvotes: 2

Carmine Checker
Carmine Checker

Reputation: 89

I think you would this: DateTime onlyDate = DateTime.Today.Date; or, that's the same DateTime onlyDate = yourDateTime.Date; So use the property Date.

Upvotes: 0

Nathanael Mayne
Nathanael Mayne

Reputation: 119

Use date.ToShortDateString() to get the date without the time component

var date = DateTime.Now
var shortDate = date.ToShortDateString() //will give you 16/01/2019

use date.ToString() to customize the format of the date

var date = DateTime.Now
var shortDate = date.ToString('dd-MMM-yyyy') //will give you 16-Jan-2019

Upvotes: 8

NoviceProgrammer
NoviceProgrammer

Reputation: 3365

The Date property will return the date at midnight.

One option could be to get the individual values (day/month/year) separately and store it in the type you want.

var dateAndTime = DateTime.Now; 
int year = dateAndTime.Year;
int month = dateAndTime.Month;
int day = dateAndTime.Day;

string.Format("{0}/{1}/{2}", month, day, year);

Upvotes: 30

mason
mason

Reputation: 32719

Create a struct that holds only the properties you want. Then an extension method to easily get that struct from an instance of DateTime.

public struct DateOnly
{
    public int Day { get; set; }
    public int Month { get; set; }
    public int Year { get; set; }
}

public static class DateOnlyExtensions
{
    public static DateOnly GetDateOnly(this DateTime dt)
    {
        return new DateOnly
        {
            Day = dt.Day,
            Month = dt.Month,
            Year = dt.Year
        };
    }
}

Usage

DateTime dt = DateTime.Now;
DateOnly result = dt.GetDateOnly();

Upvotes: 2

iwhp
iwhp

Reputation: 843

Try this, if you use a DateTimeOffset, it will also take care of the timezone

date1 = date1.LocalDateTime.Date;

If you need to add hours, use this:

date1 = date1.LocalDateTime.Date;
date1 = date1.AddHours(23).AddMinutes(59).AddSeconds(59);

Upvotes: 1

Na'il
Na'il

Reputation: 29

If you want to remove part of time from a DateTime, try using this code:

DateTime dt = new DateTime();

dt = DateTime.Now; //ex: 31/1/2017 6:30:20 PM

TimeSpan remainingTime = new TimeSpan(0, dt.Hour - 5, dt.Minute - 29, dt.Second - 19);
dt=dt.Add(remainingTime);

label1.Text = dt.ToString("HH:mm:ss"); // must be HH not hh

the output : 01:01:01

Upvotes: 0

Shaiju T
Shaiju T

Reputation: 6607

Here is another method using String.Format

    DateTime todaysDate = DateTime.UtcNow;

    string dateString = String.Format("{0:dd/MM/yyyy}", todaysDate);

    Console.WriteLine("Date with Time: "+ todaysDate.ToString());

    Console.WriteLine("Date Only : " + dateString);

Output:

Date with Time: 9/4/2016 11:42:16 AM

Date Only : 04/09/2016

This also works if the Date Time is stored in database.

For More Date and Time formatting check these links:

Reference 1

Reference 2

Hope helps.

Upvotes: 12

Matt Wilko
Matt Wilko

Reputation: 27342

I wrote a DateOnly structure. This uses a DateTime under the skin but no time parts are exposed publically:

using System;

public struct DateOnly : IComparable, IFormattable, IComparable<DateOnly>, IEquatable<DateOnly>
{

    private DateTime _dateValue;

    public int CompareTo(object obj)
    {
        if (obj == null)
        {
            return 1;
        }

        DateOnly otherDateOnly = (DateOnly)obj;
        if (otherDateOnly != null)
        {
            return ToDateTime().CompareTo(otherDateOnly.ToDateTime());
        }
        else
        {
            throw new ArgumentException("Object is not a DateOnly");
        }
    }

    int IComparable<DateOnly>.CompareTo(DateOnly other)
    {
        return this.CompareToOfT(other);
    }
    public int CompareToOfT(DateOnly other)
    {
        // If other is not a valid object reference, this instance is greater.
        if (other == new DateOnly())
        {
            return 1;
        }
        return this.ToDateTime().CompareTo(other.ToDateTime());
    }

    bool IEquatable<DateOnly>.Equals(DateOnly other)
    {
        return this.EqualsOfT(other);
    }
    public bool EqualsOfT(DateOnly other)
    {
        if (other == new DateOnly())
        {
            return false;
        }

        if (this.Year == other.Year && this.Month == other.Month && this.Day == other.Day)
        {
            return true;
        }
        else
        {
            return false;
        }
    }

    public static DateOnly Now()
    {
        return new DateOnly(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
    }

    public static bool TryParse(string s, ref DateOnly result)
    {
        DateTime dateValue = default(DateTime);
        if (DateTime.TryParse(s, out dateValue))
        {
            result = new DateOnly(dateValue.Year, dateValue.Month, dateValue.Day);
            return true;
        }
        else
        {
            return false;
        }
    }

    public static DateOnly Parse(string s)
    {
        DateTime dateValue = default(DateTime);
        dateValue = DateTime.Parse(s);
        return new DateOnly(dateValue.Year, dateValue.Month, dateValue.Day);
    }

    public static DateOnly ParseExact(string s, string format)
    {
        CultureInfo provider = CultureInfo.InvariantCulture;
        DateTime dateValue = default(DateTime);
        dateValue = DateTime.ParseExact(s, format, provider);
        return new DateOnly(dateValue.Year, dateValue.Month, dateValue.Day);
    }

    public DateOnly(int yearValue, int monthValue, int dayValue) : this()
    {
        Year = yearValue;
        Month = monthValue;
        Day = dayValue;
    }

    public DateOnly AddDays(double value)
    {
        DateTime d = new DateTime(this.Year, this.Month, this.Day);
        d = d.AddDays(value);
        return new DateOnly(d.Year, d.Month, d.Day);
    }

    public DateOnly AddMonths(int months)
    {
        DateTime d = new DateTime(this.Year, this.Month, this.Day);
        d = d.AddMonths(months);
        return new DateOnly(d.Year, d.Month, d.Day);
    }

    public DateOnly AddYears(int years)
    {
        DateTime d = new DateTime(this.Year, this.Month, this.Day);
        d = d.AddYears(years);
        return new DateOnly(d.Year, d.Month, d.Day);
    }

    public DayOfWeek DayOfWeek
    {
        get
        {
            return _dateValue.DayOfWeek;
        }
    }

    public DateTime ToDateTime()
    {
        return _dateValue;
    }

    public int Year
    {
        get
        {
            return _dateValue.Year;
        }
        set
        {
            _dateValue = new DateTime(value, Month, Day);
        }
    }

    public int Month
    {
        get
        {
            return _dateValue.Month;
        }
        set
        {
            _dateValue = new DateTime(Year, value, Day);
        }
    }

    public int Day
    {
        get
        {
            return _dateValue.Day;
        }
        set
        {
            _dateValue = new DateTime(Year, Month, value);
        }
    }

    public static bool operator == (DateOnly aDateOnly1, DateOnly aDateOnly2)
    {
        return (aDateOnly1.ToDateTime() == aDateOnly2.ToDateTime());
    }

    public static bool operator != (DateOnly aDateOnly1, DateOnly aDateOnly2)
    {
        return (aDateOnly1.ToDateTime() != aDateOnly2.ToDateTime());
    }

    public static bool operator > (DateOnly aDateOnly1, DateOnly aDateOnly2)
    {
        return (aDateOnly1.ToDateTime() > aDateOnly2.ToDateTime());
    }

    public static bool operator < (DateOnly aDateOnly1, DateOnly aDateOnly2)
    {
        return (aDateOnly1.ToDateTime() < aDateOnly2.ToDateTime());
    }

    public static bool operator >= (DateOnly aDateOnly1, DateOnly aDateOnly2)
    {
        return (aDateOnly1.ToDateTime() >= aDateOnly2.ToDateTime());
    }

    public static bool operator <= (DateOnly aDateOnly1, DateOnly aDateOnly2)
    {
        return (aDateOnly1.ToDateTime() <= aDateOnly2.ToDateTime());
    }

    public static TimeSpan operator - (DateOnly aDateOnly1, DateOnly aDateOnly2)
    {
        return (aDateOnly1.ToDateTime() - aDateOnly2.ToDateTime());
    }


    public override string ToString()
    {
        return _dateValue.ToShortDateString();
    }

    public string ToString(string format)
    {
        return _dateValue.ToString(format);
    }

    public string ToString(string fmt, IFormatProvider provider)
    {
        return string.Format("{0:" + fmt + "}", _dateValue);
    }

    public string ToShortDateString()
    {
        return _dateValue.ToShortDateString();
    }

    public string ToDbFormat()
    {
        return string.Format("{0:yyyy-MM-dd}", _dateValue);
    }
}

This is converted from VB.NET, so apologies if some conversions are not 100%

Upvotes: 6

burcu
burcu

Reputation: 526

Getting the Date part of a DateTime object didn't workout for me because I'm working on the client-side and the returned web service values have some null dates. As a result, it tries to get the Date part of a null value and it throws a runtime exception. The following example is how I solved my problem:

string dt = employer.BirthDay.ToString();
if(dt == ""){ dt = "N/A";}
else dt = dt.Substring(0,10);
  1. Get the DateTime value as string into a string variable.
  2. Check if it's null. If null, assign a string variable.
  3. If not null, get the first 10 characters of the string DateTime value and assign it to the string variable.

I'm sharing this for future reference.

Upvotes: 1

Zero
Zero

Reputation: 367

This code gives you a clear view of writing Date as well as Time separately

string time = DateTime.Now.Hour.ToString("00") + ":" + DateTime.Now.Minute.ToString("00") + ":" + DateTime.Now.Second.ToString("00");
        string date = DateTime.Now.ToString("M-dd-yyyy");
        MessageBox.Show(date + "\n" + time);

Hope this helps.

Upvotes: 1

Mani
Mani

Reputation: 2563

static void Main(string[] args)
{
    string dateStrings =  "2014-09-01T03:00:00+00:00" ;

    DateTime convertedDate = DateTime.Parse(dateStrings);
    Console.WriteLine("  {0} ----------------- {1}",

    convertedDate,DateTime.Parse(convertedDate.ToString()).ToString("dd/MM/yyyy"));

    Console.Read();
}

Upvotes: 1

Mayank Gupta
Mayank Gupta

Reputation: 89

This way of get only date without time

DateTime date = DateTime.Now;
string Strdateonly = date.ToString("d");

Output = 5/16/2015

Upvotes: 7

Guillermo Guti&#233;rrez
Guillermo Guti&#233;rrez

Reputation: 17849

I know this is an old post with many answers, but I haven't seen this way of removing the time portion. Suppose you have a DateTime variable called myDate, with the date with time part. You can create a new DateTime object from it, without the time part, using this constructor:

public DateTime(int year, int month, int day);

Like this:

myDate = new DateTime(myDate.Year, myDate.Month, myDate.Day);

This way you create a new DateTime object based on the old one, with 00:00:00 as time part.

Upvotes: 4

Filip Dialm
Filip Dialm

Reputation: 11

For using by datalist, repeater.. in aspx page:<%# Eval("YourDateString").ToString().Remove(10) %>

Upvotes: 1

TAS
TAS

Reputation: 331

If you are converting it to string, you can easily do it like this.

I'm taking date as your DateTime object.

date.ToString("d");

This will give you only the date.

Upvotes: 5

DividedByZero
DividedByZero

Reputation: 4391

Use a bit of RegEx:

Regex.Match(Date.Now.ToString(), @"^.*?(?= )");

Produces a date in the format: dd/mm/yyyy

Upvotes: 1

Jota
Jota

Reputation: 11

Use .Date of a DateTime object will ignore the time portion.

Here is code:

DateTime dateA = DateTime.Now;
DateTime dateB = DateTime.Now.AddHours(1).AddMinutes(10).AddSeconds(14);
Console.WriteLine("Date A: {0}",dateA.ToString("o"));
Console.WriteLine("Date B: {0}", dateB.ToString("o"));
Console.WriteLine(String.Format("Comparing objects A==B? {0}", dateA.Equals(dateB)));
Console.WriteLine(String.Format("Comparing ONLY Date property A==B? {0}", dateA.Date.Equals(dateB.Date)));
Console.ReadLine();

Output:

>Date A: 2014-09-04T07:53:14.6404013+02:00
>Date B: 2014-09-04T09:03:28.6414014+02:00
>Comparing objects A==B? False
>Comparing ONLY Date property A==B? True

Upvotes: 1

Saud Khan
Saud Khan

Reputation: 19

Declare the variable as a string.

example :

public string dateOfBirth ;

then assign a value like : 

dateOfBirth = ((DateTime)(datetimevaluefromDB)).ToShortDateString();

Upvotes: 1

LukeF
LukeF

Reputation: 51

I'm surprised no one has mentioned DateTime.Today

var date = DateTime.Today;
// {7/1/2014 12:00:00 AM}

See MSDN

Upvotes: 5

James
James

Reputation: 170

use 

DateTime.Now.ToString("dd-MM-yyyy");

Upvotes: 2

John
John

Reputation: 3945

Came across this post when trying to solve the original Q.

I am using Asp.Net and after some research I have found when you are binding to the value of the date in code behind, you can drop the time so it will not display on screen.

C#:

DateTime Today = DateTime.Now;

aspx:

<%: this.Today.ToShortDateString() %>

Upvotes: 2

Related Questions