Formatting DateTime type C#

Question

i have a value of DateTime type.
i want to convert it to the below format.

TO_DATE('2010-11-18 16:45:55','YYYY-MM-DD HH24:MI:SS')

i am using,

DateTime dt1 = Convert.ToDateTime(fromDateTime).ToString("YYYY-MM-DD HH24:MI:SS");

its giving error tellin "Cannot implicitly convert type 'string' to 'System.DateTime'"

please help

Sheethal

Deepak Sharma · Answer

Hi Use following format to convert a DateTime to your desired format. I have taken DateTime.Now as the DateTime : DateTime.Now.ToString(yyyy-MM-dd HH:m:s); If this answer helped you then tick the checkbox above Do you like this Answer

Shankey · Answer

hi Sheethal R Try from one of the following: // create date time 2008-03-09 16:05:07.123 DateTime dt = new DateTime(2008 3 9 16 5 7 123); String.Format({0:y yy yyy yyyy} dt); // 8 08 008 2008 year String.Format({0:M MM MMM MMMM} dt); // 3 03 Mar March month String.Format({0:d dd ddd dddd} dt); // 9 09 Sun Sunday day String.Format({0:h hh H HH} dt); // 4 04 16 16 hour 12/24 String.Format({0:m mm} dt); // 5 05 minute String.Format({0:s ss} dt); // 7 07 second String.Format({0:f ff fff ffff} dt); // 1 12 123 1230 sec.fraction String.Format({0:F FF FFF FFFF} dt); // 1 12 123 123 without zeroes String.Format({0:t tt} dt); // P PM A.M. or P.M. String.Format({0:z zz zzz} dt); // -6 -06 -06:00 time zone

Formatting DateTime type , C#