Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

Datetime in where clause

Tags:

sql

datetime

sql-server

sql-server-2005

filter

How can I select 12/20/2008 in where clause of sql?

The server is SQL server 2005.

select * from tblErrorLog where errorDate = '12/20/2008'
like image 374
Novice Developer Avatar asked Dec 22 '09 16:12

Novice Developer

People also ask

Can we use datediff in WHERE clause?

The DATEDIFF function can also be used in a WHERE clause as well as ORDER BY and HAVING clauses. The units of time available for the DATEDIFF are the same as those for the DATEADD function.

1 Answers

WHERE datetime_column >= '20081220 00:00:00.000'   AND datetime_column < '20081221 00:00:00.000'
like image 87
LukeH Avatar answered Oct 02 '22 03:10

LukeH
Sign in to Comment

Related questions

Retrieve an object from entityframework without ONE field
Linked List in SQL
Materialized View vs. Tables: What are the advantages?
What is a Covered Index?
Swap unique indexed column values in database
How to see the real SQL query in Python cursor.execute using pyodbc and MS-Access
Convert varchar into datetime in SQL Server
Rails includes with conditions
Connecting to SQL Server using windows authentication
Composite Primary Keys : Good or Bad?
What is difference between SQLite and SQL
SQL Server: Cannot insert an explicit value into a timestamp column
SQL User Defined Function Within Select
Using tuples in SQL "IN" clause
How can I tell if a VARCHAR variable contains a substring?
How to include a PHP variable inside a MySQL statement
Doing a WHERE .. IN subquery in Doctrine 2
how to increase sqlplus column output length?
Passing table name as a parameter in psycopg2
Size of VARBINARY field in SQL Server 2005

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!