SQL Comparison between dates

Question

SQL Comparison between dates

Sarvesh Pandey 71

Hi All,
On 5th of December 2022, I have created a table with date 5/12/2022.

Now when i am running the below query it is showing no recods. Note - getdate() = 5/12/2022

Getdate() - ![266919-image.png ]2

Table detail -

SQL Query -
select * from BusinessDays where Convert(varchar(2),Datepart(day,getdate())) = convert(varchar(2),'Business Day');

I have also use CAST function but still getting no ouputs

Answer accepted by question author

1 additional answer

Your answer

Answer 1

Sreeju Nair 12,756

in your query, refer to the following part,

convert(varchar(2), 'Business Day')

Replace 'Business Day' to the column name Business Day and your query will work.

select * from BusinessDays where Convert(varchar(2), DatePart(day, getdate())) = convert(varchar(2), [Business Day]);

Hope this helps

Sarvesh Pandey 71 Reputation points

2022-12-05T06:22:34.527+00:00

ohh, can you please explain what was the issue?
Sreeju Nair 12,756 Reputation points

2022-12-05T08:04:58.393+00:00
@Sarvesh Pandey

The reason is below.

See your query where you are trying to extract the date from the column "Business Day" (I just copied your query to a select query to show you what the query returns)

select convert(varchar(2), 'Business Day') from businessdays

See the output below.

Now see the query where I replaced 'Business Day' with the column name.

So in SQL query, anything inside single quotes represents a string; to represent columns you need to use column names without quotes or use [] in case you have whitespace in column names.

Hope this is clear.

Answer 2

NikoXu-msft 1,916

Hi @Sarvesh Pandey ，

Change it to this:

select * from BusinessDays where Convert(varchar(2),Datepart(day,getdate())) = convert(varchar(2),[Business Day]);

Best regards,
Niko

----------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

NikoXu-msft 1,916 Reputation points

2022-12-05T07:50:46.627+00:00
Hi @Sarvesh Pandey ,

CONVERT Syntax:

CONVERT ( data_type [ ( length ) ] , expression [ , style ] )

If you use 'Business Day', it means that you will operate on the contents of the '
The result of the operation is as follows:

It is obviously not what you want, and using [Business Day] means you will operate on this column, like this.

Best regards,
Niko

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

SQL Comparison between dates

1 additional answer

Your answer