from string to sql DateTime

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › from string to sql DateTime

Viewing 1 reply thread
  • Author
    Posts
    • December 21, 2006 at 9:10 AM #17045
      community-content

        Hello !

         

        I am trying to convert string to sql date using the following function

         public string SQLDate(string strMyDateTime)
        {
        DateTime dateTime = DateTime.Parse(strMyDateTime, System.Globalization.CultureInfo.InvariantCulture);
        return dateTime.ToString("s");
        }

        not mapping ! any ideas thanks

         Lucas

         

        Any idea how to fix this error thanks

      • December 22, 2006 at 2:08 AM #17052
        community-content

          Seems function is working fine.

          I tried passing  "10/13/2006"

          I got Output as "2006-10-13T00:00:00"

          Well what Output are you expecting. And other thing what Input are you trying to pass.

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.