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
Loading
Deepak SharmaPosted Nov 19, 2010, 1:03 AM
DateTime.Now.ToString("yyyy-MM-dd HH:m:s");
If this answer helped you, then tick the checkbox above "Do you like this Answer"
ShankeyPosted Nov 19, 2010, 12:45 AM
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