sybase varchar to datetime

I have to take a string that has month, day, year, hour, min AM/PM and select from a table that has a datetime column. How can I do this? I have seen some examples of custom queries, but this seems a bit cumber开发者_开发知识库some considering I have the flexibility to manipulate the string however I want to.