Handling date in SQL Server

by

Don’t pass dates as strings. Pass them as DateTime.
The .Net DateTime maps directly to SQL Server’s DateTime. All you have to do is parse the string to a DateTime struct in your .Net code and pass it as a parameter to your stored procedure.
To search for a specific date and ignore the Time portion of the DateTime, better use >= and < in your sql:

select * 
from table 
where acceptedDate >= @Date
AND acceptedDate < DATEADD(DAY, 1, @Date);

More Related Contents:

  1. T-SQL stored procedure that accepts multiple Id values
  2. Sql Server string to date conversion
  3. Select columns from result set of stored procedure
  4. How to get Time from DateTime format in SQL?
  5. Escape a string in SQL Server so that it is safe to use in LIKE expression
  6. How to get first and last day of previous month (with timestamp) in SQL Server
  7. How to remove the time portion of a datetime value (SQL Server)?
  8. Dapper.NET and stored proc with multiple result sets
  9. How to list all dates between two dates [duplicate]
  10. SQL Server sp_msforeachtable usage to select only those tables which meet some condition
  11. Date conversion and culture: Difference between DATE and DATETIME
  12. SQL Query to find the last day of the month
  13. EXEC sp_executesql with multiple parameters
  14. T-SQL Dynamic SQL and Temp Tables
  15. How do I search an SQL Server database for a string?
  16. Calling an API from SQL Server stored procedure
  17. Retrieve data from stored procedure which has multiple result sets
  18. How can I get the sum of multiple datetime values?
  19. Comparing dates stored as varchar
  20. Programmatically retrieve SQL Server stored procedure source that is identical to the source returned by the SQL Server Management Studio gui?
  21. Avoid Naming User Stored Procedures SP% or SP_%
  22. Execute stored procedure with an Output parameter?
  23. Retrieving the date in SQL Server; CURRENT_TIMESTAMP vs GetDate()
  24. Convert UTC Milliseconds to DATETIME in SQL server
  25. Undesired rounding of DateTime in SQL Server
  26. How to convert text column to datetime in SQL
  27. SQL Server stored procedure return code oddity
  28. ODBC Call Failed with stored procedure – Pass through query
  29. How to calculate difference in hours (decimal) between two dates in SQL Server?
  30. Why can’t Entity Framework see my Stored Procedure’s column information?

Leave a Comment