10 Replies Latest reply: Dec 19, 2007 11:06 AM by 596442 RSS

    Convert String to Datetime

      I have date and time stored as a STRING datatype in this format.
      2007-01-01 12:00:01 AM

      Now I want all the results greater than some date and time e.g. "2007-09-01 12:00:01 AM" and for that I need to convert the string datatype to DATETIME datatype to make this mathematical expression work. Any help on how can I achieve this or is there any other workaround?