TO_DATE() Function in SQL Server

developers with Oracle or Java background usually ask one same question “is there any equivalent function TO_DATE() to convert string into datetime or to get different formats of date ?”