Date query?

Accepted answer

Hi,

when you compare the date time, always you need to ensure that you are checking the date time format in equally. Otherwise you need to convert into common format which will solve your business requirement.

brunda k14y ago

Accepted answer

convert(smalldatetime,'03/30/2012 22:40:00')

http://msdn.microsoft.com/en-us/library/ms187928.aspx

Kunal Vaishya14y ago

Accepted answer

Dear first

try
1955-12-13 12:43:10 Format to convert small date time

Date=convert(smalldatetime, '2012-12-13 22:40:00')

let me know tit work or not

sathish kumar14y ago

yr D m Hr Min Sec
DateTime startDate= new DateTime(2005 ,2 ,1 ,3, 4 , 56);

DateTime EndDate= new DateTime(2008,2,1,3,4,12);

TimeSpan DiffDate= EndDate.Subtract(StartDate)

console.writline(DiffDate.Days.Tostring() + "Days"); ---DateWise Diff

console.writline(DiffDate.Hours.Tostring() + "Hours");

console.writline(DiffDate.Minutes.Tostring() + "Minutes");

Tryout this....

Vulpes14y ago

Does it work if you re-express the date in this format?

'2012-03-30 22:40:00'