I'm new to the RadDateTimePicker and I'm wondering if the control can allow me to
round the SelectedValue to the minute (to effectively zero-out the seconds and milliseconds portion).
I need it for calling a stored procedure with a SMALLDATETIME Parameter (which I'm not allowed to change).
So before I consider writing a ValueConverter for this, I need to know if the RadDateTimePicker control exposes a property for rounding to the minute ?
Right now the milliseconds is being passed to the stored procedure which is causing a conversion error.
(because the
My goal is to call the stored procedure such as below to avoid the conversion error.
round the SelectedValue to the minute (to effectively zero-out the seconds and milliseconds portion).
<telerik:RadDateTimePicker SelectedValue="{Binding TheVisitDateTime, Mode=TwoWay}"/>I need it for calling a stored procedure with a SMALLDATETIME Parameter (which I'm not allowed to change).
So before I consider writing a ValueConverter for this, I need to know if the RadDateTimePicker control exposes a property for rounding to the minute ?
Right now the milliseconds is being passed to the stored procedure which is causing a conversion error.
(because the
@dVisitDateTime is SMALLDATETIME data type).exec schma.CompleteClientVisit @iVisitID = 1, @dVisitDateTime = '2011-11-22 15:47:10.25039', ...other params...Msg 8114, Level 16, State 1, Procedure CompleteClientVisit, Line 0Error converting data type varchar to smalldatetime.My goal is to call the stored procedure such as below to avoid the conversion error.
exec schma.CompleteClientVisit @iVisitID = 1, @dVisitDateTime = '2011-11-22 15:47:00', ...other params...