I'm working on Windows Form and i have selected Rad TimePicker for time insertion into sql server.
i want to insert time in the form of 11:23 AM/PM . Value inserted into sql server is in 11:23:00 format not in 11:23 AM/PM format.
Please guide me.
1 Answer, 1 is accepted
0
Hello Mian,
Thank you for writing.
The RadTimePicker.Value property always tries to parse the text in the editable part to DateTime. That is why the Value is supposed to return a DateTime value. In order to keep only the time part in a specific format, you can store TimePickerElement.MaskedEditBox.Text property instead. Additionally, you can specify the desired format by setting the TimePickerElement.Format property.
I hope this information helps. Should you have further questions, I would be glad to help.
Regards,
Dess
Telerik
Thank you for writing.
The RadTimePicker.Value property always tries to parse the text in the editable part to DateTime. That is why the Value is supposed to return a DateTime value. In order to keep only the time part in a specific format, you can store TimePickerElement.MaskedEditBox.Text property instead. Additionally, you can specify the desired format by setting the TimePickerElement.Format property.
I hope this information helps. Should you have further questions, I would be glad to help.
Dess
Telerik
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items