How to search record by date in SQL Server?

Question

Aryan Kumar · Answer

To search record by date in SQL Server, you can use the WHERE clause to filter the results by the date column. For example, the following query will return all records from the products table where the date_created column is greater than or equal to 2023-01-01:

SQL

SELECT *
FROM products
WHERE date_created >= '2023-01-01';

You can also use the BETWEEN operator to search for records between two dates. For example, the following query will return all records from the products table where the date_created column is between 2023-01-01 and 2023-01-31:

SQL

SELECT *
FROM products
WHERE date_created BETWEEN '2023-01-01' AND '2023-01-31';

Here are some other ways to search record by date in SQL Server:

Use the LIKE operator to search for records that match a certain pattern. For example, the following query will return all records from the products table where the date_created column contains the string "2023":

SQL

SELECT *
FROM products
WHERE date_created LIKE '%2023%';

Use the IN operator to search for records that are in a list of dates. For example, the following query will return all records from the products table where the date_created column is in the list of dates ['2023-01-01', '2023-01-02', '2023-01-03'].

SQL

SELECT *
FROM products
WHERE date_created IN ('2023-01-01', '2023-01-02', '2023-01-03');

Rocky Dada · Answer

To search records by date in SQL Server, you can use the WHERE clause in a SELECT statement along with the appropriate comparison operator to compare the date values in your table with a specific date or date range. Here are a few examples:

Search for records on a specific date:

SELECT * FROM your_table WHERE date_column = '2023-04-10';

Replace your_table with the name of your table and date_column with the name of the column that contains your date values. This query will return all records where the date value in date_column is equal to the specified date (in this case, '2023-04-10').

Search for records within a date range:

SELECT * FROM your_table WHERE date_column BETWEEN '2023-04-01' AND '2023-04-10';

This query will return all records where the date value in date_column falls within the specified date range (in this case, from '2023-04-01' to '2023-04-10').

Note that in both examples, the date values are enclosed in single quotes. This is because date values in SQL Server are treated as strings and need to be enclosed in quotes for the query to work correctly.

ID	Name	Date
1	John Doe	2023-04-01
2	Jane Doe	2023-04-02
3	Bob Smith	2023-04-02
4	Alice Lee	2023-04-03

Revati S Misra · Answer

You can select the record date-wise after converting the date column datatype of the table into another datatype.

Syntax:

SELECT * FROM Table_Name WHERE CONVERT(DataType, Column_Name, format) = ‘DD-MM-YYYY’;

Example:

SELECT * FROM Customers WHERE CONVERT(VARCHAR, Join_Date, 105) = ‘01-01-2020’

interview

How to search record by date in SQL Server?

Can you answer this question?

3 Answers