string-to-datetime

Sql Server string to date conversion

I want to convert a string like this: '10/15/2008 10:06:32 PM' into the equivalent DATETIME value in Sql Server. In Oracle, I would say this: TO_DATE('10/15/2008 10:06:32 PM','MM/DD/YYYY HH:MI:SS AM') This question implies that I must parse the string into one of the standard formats, and then convert using one of those codes. Th...

str_to_date function in sql server?

MySQL has a function called STR_TO_DATE, that converts a string to date. Question: Is there a similar function in SQL Server? ...