Getting the date only in Convert.ToDateTime() in asp.net

Question

Hi, I have a parameter string that passes date value to a stored proc

cmdItemSearch.Parameters.Add(new SqlParameter("@EndDate", SqlDbType.DateTime));
cmdItemSearch.Parameters["@EndDate"].Value = Convert.ToDateTime(DateTime.Now);

The value being passed is "6/30/2010 7:45:00 AM"

I want to pass only "6/30/2010" How would I do that?

Answer 1

cmdItemSearch.Parameters["@EndDate"].Value = DateTime.Today;

Note that the Today property simply returns a DateTime with the time element set to midnight.

Answer 2

MSDN to the rescue: http://msdn.microsoft.com/en-us/library/system.datetime.date.aspx

DateTime date1 = new DateTime(2008, 6, 1, 7, 47, 0);
Console.WriteLine(date1.ToString());

// Get date-only portion of date, without its time.
DateTime dateOnly = date1.Date;
// Display date using short date string.
Console.WriteLine(dateOnly.ToString("d"));

Answer 3

For starters, DateTime.Now is already a DateTime so doesn't need to be converted as you have.

Secondly, you can obtain just the date of Today by using DateTime.Today instead of DateTime.Now.

However, if your date isn't "today" then you can just use yourDateTime.Date to return just the Date.

Answer 4

If you are looking for the mm/dd/yyyy format, you could use

DateTime.Now.ToShortDateString()

That will return the short format, but depends on the current culture