How to convert a “dd/mm/yyyy” string to datetime in SQL Server?

by

The last argument of CONVERT seems to determine the format used for parsing. Consult MSDN docs for CONVERT.

111 – the one you are using is Japan yy/mm/dd.

I guess the one you are looking for is 103, that is dd/mm/yyyy.

So you should try:

 SELECT convert(datetime, '23/07/2009', 103)

More Related Contents:

  1. How to convert Seconds to HH:MM:SS using T-SQL
  2. Truncate Datetime to Second (Remove Milliseconds) in T-SQL
  3. String.Format like functionality in T-SQL?
  4. Converting a String to DateTime
  5. How to change the datetime format in Pandas
  6. Converting string to Date and DateTime
  7. How can I convert bigint (UNIX timestamp) to datetime in SQL Server?
  8. How can I use optional parameters in a T-SQL stored procedure?
  9. How to get Time from DateTime format in SQL?
  10. T-SQL Decimal Division Accuracy
  11. Selecting a Record With MAX Value
  12. Check if string has date, any format
  13. Find index of last occurrence of a sub-string using T-SQL
  14. What is a “batch”, and why is GO used?
  15. TSQL divide by zero encountered despite no columns containing 0
  16. T-SQL loop over query results
  17. How to insert default values in SQL table?
  18. How to Round a Time in T-SQL
  19. Parse C# string to DateTime
  20. Return a value if no rows are found in Microsoft tSQL
  21. Check if a varchar is a number (TSQL)
  22. Using Aliases in Where Clause or an Alternative Option?
  23. Extract the first word of a string in a SQL Server query
  24. SQL to find first non-numeric character in a string
  25. T-SQL Split Word into characters
  26. Search for one value in any column of any table inside a database
  27. Check if a varchar is a number (T-SQL)
  28. Convert unix epoch timestamp to TSQL datetime
  29. Poor Man’s SQL Pivot. List Questions as Columns and Answers per User in one row
  30. Convert string to datetime in vb.net

Leave a Comment