how to calculate date only from datetime object

Try this:

DateTime dt = DateTime.ParseExact("29-04-2012", "dd-MM-yyyy", CultureInfo.InvariantCulture);

This will help you more:

// create date time 2008-03-09 16:05:07.123
DateTime dt = new DateTime(2008, 3, 9, 16, 5, 7, 123);
 
String.Format("{0:y yy yyy yyyy}", dt);  // "8 08 008 2008"   year
String.Format("{0:M MM MMM MMMM}", dt);  // "3 03 Mar March"  month
String.Format("{0:d dd ddd dddd}", dt);  // "9 09 Sun Sunday" day
String.Format("{0:h hh H HH}",     dt);  // "4 04 16 16"      hour 12/24
String.Format("{0:m mm}",          dt);  // "5 05"            minute
String.Format("{0:s ss}",          dt);  // "7 07"            second
String.Format("{0:f ff fff ffff}", dt);  // "1 12 123 1230"   sec.fraction
String.Format("{0:F FF FFF FFFF}", dt);  // "1 12 123 123"    without zeroes
String.Format("{0:t tt}",          dt);  // "P PM"            A.M. or P.M.
String.Format("{0:z zz zzz}",      dt);  // "-6 -06 -06:00"   time zone

Have a look on this article:
Easy String to DateTime, DateTime to String and Formatting[^]
Convert date from Hijri Calendar to Gregorian Calendar and vise versa[^]
Formatting a DateTime for display - format string description[^]

DateTime myDT = DateTime.Now.Date;

That will give you just the date!

EDIT: Also remember, if your field in SQL is a DateTime field, it will always save a time, even if you dont supply one. If you want just the date, change the column to be a Date column.

When you get the data back in C#, if you want to just get the string of the date, just use:

DateTime myDT = DateTime.Now;
myDT.ToShortDateString();

This may help you
http://msdn.microsoft.com/en-us/library/system.datetime.date.aspx[^]
http://stackoverflow.com/questions/1026841/how-to-get-only-time-from-date-time[^]

simply run this query in sql server...

select rtrim(convert(char,getdate(),103)) + '  '+ ltrim(rtrim(substring(convert(char,getdate(),109),13,8))) + ' '+ ltrim(substring(convert(char,getdate(),109),25,2)) as time

mark it solution if you got your answer and dont forget to rate it...


Thanks

Ashish