Use TO_DATE in SQL Server 2012

user_8205057 0
Viewed 73975

I have a problem. When I execute this SQL statement in SQL Server 2012:

TO_DATE('2011-11-09 00:00:00','YYYY-MM-DD HH24:MI:SS')

I get an error:

'TO_DATE' not is a name de function integrate recognized.

What is the solution?

Thanks!

sql-server-2012
3 Answers

CONVERT In Sql Server Can Do The Same Job Of TO_DATE In Oracle 

SELECT CONVERT(date, yourDate ,104)
user_83703340
Related