SQL Filter by Date

Question

Hello,

I have some records like this picture, we can see i have data with today time stamp for some days.

Now when i make an query to filter to get record for today with below syntax and i found no result.

Anyone know why?

select top 10 * from InterfaceTrafficByDays where datetime= CAST( GETDATE() AS Date )

Answer 1

Hi @Handian Sudianto

I tun the query in this morning at 06.30 and below 07AM with no result

You run this query 12/13/2023 06.30 and at the same time the Top 10 datas in InterfaceTrafficByDays table are all 12-12-2023. That's why you got no result with this condition where Datetime = cast(getdate() as date).

but if i test now i got the result. Its strange for me.

Check if the InterfaceTrafficByDays table have records of 12-13-2023 now. As I guessed, you got the result now because records of 12-13-2023 are inserted.

Best regards,

Cosmog Hong

Answer 2

Hi @Handian Sudianto

I have done a test.

create table test(id int,DateTime datetime);
insert into test values
(1,'2023-12-12'),
(2,'2023-12-13');

select top 1 * from test where Datetime = cast(getdate() as date);

There does not seem to be a problem with the query.

Did you run that query yesterday?

Maybe you need to provide test data.

Best regards,

Percy Tang