Setting time in DateTimePicker

[John Valescu]

Is there a way to force the time to midnight, 00:00:00 when saving to a SQL server database regardless of the current time?

Thanks!

[Anupama Roy]

Hi, You can consider writing something like this inorder to force the time to "00:00:00" .Here the variable "t" checks for the time and finally returns the value you want. TimeSpan t=this.dateTimePickerAdv1.Value.TimeOfDay; if(t>TimeSpan.Parse ("00:00:00") || t

[Anupama Roy]

Hi , The code snippet seems to be chewed up.Please take a look at this. TimeSpan t=this.dateTimePickerAdv1.Value.TimeOfDay; if(t>TimeSpan.Parse ("00:00:00") || t

[Anupama Roy]

Hi, Take a look at the sample for the above mentioned code snippet. Sample Regards, Anu.

[John Valescu]

Anu, Thanks for the quick response. I actually want to change the time to 00:00:00 before commiting it to the SQL database. I''ve tried changing some of the members of the class, but most of them are read-only. >Hi, > >Take a look at the sample for the above mentioned code snippet. >Sample > > >Regards, > >Anu. > >