interview

Home / DeveloperSection / Interviews / How to search record by date in SQL Server?

Ask Question
Revati S Misra

Revati S Misra

Follow
Skilled in SEO, content writing, and digital marketing. Completed several years of working in many organizations including multinational companies. I love to learn new things in life that keep me motivated.

Can you answer this question?

Answer

3 Answers

Aryan Kumar

Aryan Kumar

20-Jun-2023

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

Rocky Dada

10-Apr-2023

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

Revati S Misra

05-Apr-2023

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’

Liked By