{"id":46,"date":"2014-03-28T16:35:00","date_gmt":"2014-03-28T21:35:00","guid":{"rendered":"https:\/\/www.chrystalsander.com\/blog\/?p=46"},"modified":"2023-07-26T12:10:42","modified_gmt":"2023-07-26T17:10:42","slug":"net-formatting-a-date-for-oracle","status":"publish","type":"post","link":"https:\/\/www.chrystalsander.com\/blog\/?p=46","title":{"rendered":"NET : Formatting A Date For Oracle"},"content":{"rendered":"
\nCurrently, developers must provide
\ndate format whenever inserting date records into oracle.  Here is one approach:<\/div>\n
\n<\/div>\n
\n<\/p>\n
\npublic<\/span> static<\/span> DateTime<\/span> FormatDateForOracle(string<\/span> inDate)<\/o:p><\/span><\/div>\n
\n  {<\/o:p><\/span><\/div>\n
\n  \/\/try to parse date into the acceptable Oracle format<\/span><\/o:p><\/span><\/div>\n
\n  DateTime<\/span> parsedDate;<\/o:p><\/span><\/div>\n
\n<\/div>\n
\n  if<\/span> (DateTime<\/span>.TryParse(inDate,
\nout<\/span> parsedDate))<\/o:p><\/span><\/div>\n
\n  {<\/o:p><\/span><\/div>\n
\n    try<\/span><\/o:p><\/span><\/div>\n
\n        {<\/o:p><\/span><\/div>\n
\n          return<\/span> parsedDate =       DateTime<\/span>.ParseExact(Convert<\/span>.ToDateTime(inDate).ToString(“MM\/dd\/yyyy”<\/span>), “MM\/dd\/yyyy”<\/span>,
\nSystem.Globalization.CultureInfo<\/span>.InvariantCulture);<\/o:p><\/span><\/div>\n
\n        }<\/o:p><\/span><\/div>\n
\n    catch<\/span> (Exception<\/span>
\ne)<\/o:p><\/span><\/div>\n
\n        {<\/o:p><\/span><\/div>\n
\n          \/\/Handle as you see fit<\/span><\/o:p><\/span><\/div>\n
\n        }<\/o:p><\/span><\/div>\n
\n  }<\/o:p><\/span><\/div>\n
\n  else<\/span><\/o:p><\/span><\/div>\n
\n    {<\/o:p><\/span><\/div>\n
\n       \/\/Handle as you see fit<\/span><\/o:p><\/span><\/div>\n
\n    }<\/o:p><\/span><\/div>\n
\n    return<\/span>
\nparsedDate;<\/o:p><\/span><\/div>\n
\n}<\/o:p><\/span><\/div>\n<\/div>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

Currently, developers must provide date format whenever inserting date records into oracle.  Here is one approach: public static DateTime FormatDateForOracle(string inDate)   {   \/\/try to parse date into the acceptable Oracle format   DateTime parsedDate;   if (DateTime.TryParse(inDate, out parsedDate))   {     try         {           return parsedDate =       DateTime.ParseExact(Convert.ToDateTime(inDate).ToString(“MM\/dd\/yyyy”), “MM\/dd\/yyyy”, … Continue reading “NET : Formatting A Date For Oracle”<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[45],"tags":[39,43],"_links":{"self":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/46"}],"collection":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=46"}],"version-history":[{"count":1,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/46\/revisions"}],"predecessor-version":[{"id":170,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/46\/revisions\/170"}],"wp:attachment":[{"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=46"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=46"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chrystalsander.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=46"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}