date function - Urgent

Hello Guys,
I have just migrated from Oracle to MS SQl Server Database. I need to know a function in SQL for converting the date format - as there is in Oracle "to_date(value,'format') ?
Can anyone help me please
Thanks
AsthaOriginally posted by astha_raj
Hello Guys,

I have just migrated from Oracle to MS SQl Server Database. I need to know a function in SQL for converting the date format - as there is in Oracle "to_date(value,'format') ?

Can anyone help me please

Thanks
Astha

Hope the below helps.

select myDate = convert(varchar(10),thevalue,101)