How to parse string into date?

by 
CONVERT(datetime, '24.04.2012', 104)

Should do the trick. See here for more info: CAST and CONVERT (Transact-SQL)

More Related Contents:

  1. Can I use the MERGE statement in SQL Server 2005?
  2. Insert results of a stored procedure into a temporary table
  3. Check if table exists in SQL Server
  4. Levenshtein distance in T-SQL
  5. Select query to remove non-numeric characters
  6. How important is the order of columns in indexes?
  7. Using the result of an expression (e.g. Function call) in a stored procedure parameter list?
  8. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  9. best way to convert and validate a date string
  10. Convert Xml to Table SQL Server
  11. T-SQL Pivot? Possibility of creating table columns from row values
  12. Drop all the tables, stored procedures, triggers, constraints and all the dependencies in one sql statement
  13. For Nvarchar(Max) I am only getting 4000 characters in TSQL?
  14. How do I group on continuous ranges
  15. “select * from table” vs “select colA, colB, etc. from table” interesting behaviour in SQL Server 2005
  16. Find non-ASCII characters in varchar columns using SQL Server
  17. Is it possible to perform multiple updates with a single UPDATE SQL statement?
  18. t-sql get all dates between 2 dates [duplicate]
  19. Extracting hours from a DateTime (SQL Server 2005)
  20. Incorrect syntax near the keyword ‘with’…previous statement must be terminated with a semicolon
  21. How to pivot table with T-SQL?
  22. Testing for inequality in T-SQL
  23. Replace a newline in TSQL
  24. T-SQL – function with default parameters
  25. How to use an Alias in a Calculation for Another Field
  26. How do you copy a record in a SQL table but swap out the unique id of the new row?
  27. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  28. Poor Man’s SQL Pivot. List Questions as Columns and Answers per User in one row
  29. Compare dates in T-SQL, ignoring the time part
  30. Sql Server : How to use an aggregate function like MAX in a WHERE clause

Leave a Comment