Covert to SQL Server Format

[Tony Casey]

Hi Guys,

I have searched through the forum and cannot find how to convert the date into an SQL format string.

When the date is submitted it is in the "dd-mm-yyyy hh-mm-ss" format, trouble is, SQL Server stores its dates in "yyyy-mm-dd hh-mm-ss" format.

Is there a way of converting the date to SQL server date, I dont want the display date to look like the SQL date.

Thanks in advance.

[Tony Casey]

Had to do it manually...

if (!RadDatePickerJobTo.SelectedDate.ToString().Equals(String.Empty))
{

                sql += " AND Job_CreatedDate <= '" + RadDatePickerJobTo.SelectedDate.Value.Year + "-" + RadDatePickerJobTo.SelectedDate.Value.Month + "-" + RadDatePickerJobTo.SelectedDate.Value.Day + " 23:59:00.000'";

}