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 cumbersome considering I have the flexibility to manipulate the string however I want to.
Asked
Active
Viewed 1,009 times
0
-
You want to convert string to datetime, am I right? – Andrei Petrenko Jul 06 '11 at 19:39
-
yes, I do want to convert string to datetime – richsoni Jul 07 '11 at 15:31
-
Thanks, I guess I did not think of wording it that way, and I found it here http://stackoverflow.com/questions/56303/how-to-convert-a-string-to-a-date-in-sybase – richsoni Jul 07 '11 at 15:32