How to get only date value in C#

[aviskumar]

How to get only date value in C#.

i am using system.datetime.now.date
it returns date with time.

Can any one give the solution


Regards,
sivakumar

[klintan]

There is no date type in .Net, only DateTime.

To get only date you can do one of the following:

// Get current date and time
DateTime dt=DateTime.Now;

// Get year, month, and day
int year=dt.Year;
int month=dt.Month;
int day=dt.Day;

// Get datetime at midnight
DateTime date=dt.Date;

// Get long date string
string longDate=dt.ToLongDateString();

// Get short date string
string shortDate=dt.ToShortDateString();

// Get Ole Automation Date (number of days from midnight, 30 December 1899)
double oaDate=dt.ToOADate();

[aviskumar]

using ultradatetimeeditor.value i am storing it in database and its value in database is 2005-08-18 00:00:00.000
and when i try to use
DateTime.Now.Date.ToShortDateString() its not retreive the record.

How come will i get the record by passing exact value as in database

Pls. give information.

Regards,
Sivakumar.kr

[parnati]

try this way.


txtDueDate.MaskInput = "{LOC}mm/dd/yyyy";

[Norfy]

If your DB column type is "DATE" it should work.

If your column type is TIMESTAMP you may have to make your query a range. eg. WHERE col >= today AND col < tomorrow