Adding From and to Hour filter with From and To date filter

1

Is it possible to add From and To Hour filter along with from and to date filter using native query?

2

Hi @Bhaumik1
Yes, by creating 4 different filters.
There's a request for adding time to the Between filter on SQL questions:
https://github.com/metabase/metabase/issues/7418 - upvote by clicking :+1: on the first post

3

How do i create from and to hour filter?
Can you please help me with the format?
I am using this query and fetching date and time from timestamp column but unable to apply from and to hour filter.
SELECT count(ID)
FROM Table
WHERE TIMESTAMP_ADD(timestamp, INTERVAL 330 MINUTE) BETWEEN {{Start_Date}} AND TIMESTAMP_ADD({{End_Date}}, INTERVAL 1 DAY)

4

@Bhaumik1 I have no idea which database type you're querying, or if you are trying to filter by datetime or if you are looking to be able to filter hours independently.
Try writing a query without any variables, just with hardcoded data - then it's easier to know how/where to add variables.