Convert from string to datatime in sql [duplicate]

by

use this:

select itemid from issue where CONVERT(nvarchar(12), duedate, 105) < '20/11/2016'

More Related Contents:

  1. How can I insert a new database record in the middle of an existing table?
  2. Convert text to system date format [duplicate]
  3. How to get a particular preceding value of a column in SQL [closed]
  4. Whats wrong in this sql query? It throws error [closed]
  5. INNER JOIN ON vs WHERE clause
  6. Why is SELECT * considered harmful?
  7. How to declare a variable in a PostgreSQL query
  8. SQL Server : Columns to Rows
  9. How to group time by hour or by 10 minutes
  10. Why no windowed functions in where clauses?
  11. HIVE select count(*) non null returns higher value than select count(*)
  12. T-SQL Cast versus Convert
  13. SQL Case Sensitive String Compare
  14. SQL how to make null values come last when sorting ascending
  15. convert Excel Date Serial Number to Regular Date
  16. SQL – How to transpose?
  17. Partition Function COUNT() OVER possible using DISTINCT
  18. Calculate business days in Oracle SQL(no functions or procedure)
  19. RBAR vs. Set based programming for SQL
  20. Performance issue in using SELECT *? [duplicate]
  21. How to read the contents of an .sql file into an R script to run a query?
  22. Designing a SQL schema for a combination of many-to-many relationship (variations of products)
  23. SQL INNER JOIN syntax
  24. Select distinct from multiple fields using sql
  25. SELECT max(x) is returning null; how can I make it return 0?
  26. How to return default value from SQL query
  27. SQL INSERT INTO from multiple tables
  28. Conditional aggregation performance
  29. Retrieve Oracle last inserted IDENTITY
  30. RegEx to Detect SQL Injection

Leave a Comment