convert datetime c# to date sql server code example

Example 1: c# SqlDateTime to datetime

DateTime dt = SqlDateTime.MinValue.Value;

Example 2: c# datetime to sql server datetime

DateTime myDateTime = DateTime.Now;
string sqlFormattedDate = myDateTime.ToString("yyyy-MM-dd HH:mm:ss.fff");