SQL Date format BETWEEN query

by

I realize you said just SQL, but it doesn’t seem like you’re getting much help, so I’m going to show you how I would go about this using MySQL and hopefully it will help:

In C#, create the query string like this:

string date1 = dt1.ToString("D");
string date2 = dt2.ToString("D");
string query = "SELECT * FROM customer WHERE cast(entered_date_time as date) > STR_TO_DATE('" + date1 + "', '%W, %M %d, %Y') AND cast(entered_date_time as date) < STR_TO_DATE('" + date2 + "', '%W, %M %d, %Y');";

To give you a better view of the query, here’s a sample what I’m doing:

SELECT * FROM customer WHERE
cast(entered_date_time as date) > STR_TO_DATE('Monday, October 01, 2012', '%W, %M %d, %Y')
AND
cast(entered_date_time as date) < STR_TO_DATE('Tuesday, October 02, 2012', '%W, %M %d, %Y')

Also notice I used the field entered_date_time since date is a reserved keyword in MySQL.

More Related Contents:

  1. How do I update a value in C# and SQL Server? [closed]
  2. Error: You have an error in your SQL syntax – but SQL statement works
  3. Store value in Yes/No field in Access using C#
  4. How to save leap date ’02/29/2006′ to sql server database? [duplicate]
  5. Fastest Way of Inserting in Entity Framework
  6. Execute Insert command and return inserted Id in Sql
  7. Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints
  8. Adding multiple parameterized variables to a database in c#
  9. C# SQL Server – Passing a list to a stored procedure
  10. Difference between Parameters.Add(string, object) and Parameters.AddWithValue
  11. How do I connect to an MDF database file?
  12. SQL injection on INSERT
  13. SQL WHERE clause matching values with trailing spaces
  14. Equivalent of SQL ISNULL in LINQ?
  15. SqlBulkCopy from a List
  16. How to fill Dataset with multiple tables?
  17. The C# using statement, SQL, and SqlConnection
  18. C# constructing parameter query SQL – LIKE %
  19. Generate class from database table
  20. Passing a SQL parameter to an IN() clause using typed datasets in .NET
  21. What is passing parameters to SQL and why do I need it?
  22. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  23. Calling a SQL User-defined function in a LINQ query
  24. How to create NVarchar(max) Sqlparameter in C#? [duplicate]
  25. Enabling Foreign key constraints in SQLite
  26. no overload for method “ToString” takes 1 arguments
  27. Stored procedure returns int instead of result set
  28. How to use String property as primary key in Entity Framework
  29. Generating sql code programmatically
  30. Do we have transactions in MS-Access?

Leave a Comment