Use TO_DATE in SQL Server 2012

by

SQL-Server has no TO_DATE function. You have to use convert.
See here

-- Specify a datetime string and its exact format
SELECT TO_DATE('2012-06-05', 'YYYY-MM-DD') FROM dual;


-- Specify a datetime string and style 102 (ANSI format), raises an error if conversion fails
  SELECT CONVERT(DATETIME, '2012-06-05', 102);

  -- TRY_CONVERT available since SQL Server 2012 (returns NULL if conversion fails)
  SELECT TRY_CONVERT(DATETIME, '2012-06-05', 102);

For your specific case use:

convert(DATETIME, '2011-11-09 00:00:00')

More Related Contents:

  1. Enable remote connections for SQL Server Express 2012
  2. Wait on the Database Engine recovery handle failed!! SQL Server 2012 installation
  3. Code first custom SQL migration timeout exception
  4. I dont know sql syntax for my table [closed]
  5. Sql to select the rows and ignore the duplicate userid in SQL Server [closed]
  6. nvarchar concatenation / index / nvarchar(max) inexplicable behavior
  7. How to check if a column exists in a SQL Server table
  8. Auto increment primary key in SQL Server Management Studio 2012
  9. SQL Server 2012 column identity increment jumping from 6 to 1000+ on 7th entry [duplicate]
  10. XML Server XML performance optimization
  11. Default row order in SELECT query – SQL Server 2008 vs SQL 2012
  12. Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 1, current count = 0
  13. Scope of temporary tables in SQL Server
  14. Adding a query hint when calling Table-Valued Function
  15. Getting total row count from OFFSET / FETCH NEXT
  16. Last executed queries for a specific database
  17. Get previous and next row from rows selected with (WHERE) conditions
  18. Avg of float inconsistency
  19. Dynamically assign filename to excel connection string
  20. SQL Server Configuration Manager cannot be found
  21. Convert Date format into DD/MMM/YYYY format in SQL Server
  22. Replace first occurrence of substring in a string in SQL
  23. How to correctly insert newline in nvarchar [duplicate]
  24. SSIS Package Not Running as 32bit in SQL Server 2012
  25. “No backupset selected to be restored” SQL Server 2012
  26. The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions
  27. Cannot Resolve Collation Conflict
  28. Try_Convert for SQL Server 2008 R2
  29. How to get Previous Value for Null Values
  30. Can’t create stored procedure with table output parameter

Leave a Comment