Convert date time to proper format

string day=System.DateTime.Now.Day;
string month=System.DateTime.Now.Month;
string Year=System.DateTime.Now.Year;
string hour=System.DateTime.Now.Hour;
string second=System.DateTime.Now.Second;
string minute=System.DateTime.Now.Minute;

Then you can play with them!:

string myTime=String.Format("{0}-{1}-{2}:{3}:{4}:{5}",year,month,day,hour,minute,second);

DateTime dat = new DateTime(2012, 1, 17, 9, 30, 0);
string city = "Chicago";
int temp = -16;
string output = String.Format("At {0} in {1}, the temperature was {2} degrees.",
                              dat, city, temp);
Console.WriteLine(output);
// The example displays the following output:
//    At 1/17/2012 9:30:00 AM in Chicago, the temperature was -16 degrees.

VALUES
          (
           ,convert(datetime,@StartDt,103)  --It's avoid +22 in my date
           ,convert(datetime,@EndDt,103)
          )

System.Date.Now