Answers for "how to query dates in sql"

SQL
0

how to query date in sql server

select  *
from events
where event_date between '2020-01-01' and '2020-01-31';

-- can include time by specifying in YYYY-MM-DD hh:mm:ss format:
select  *
from events
where event_date between '2020-01-01 12:00:00' and '2020-01-01 23:30:00';
Posted by: Guest on September-20-2021

Code answers related to "how to query dates in sql"

Code answers related to "SQL"

Browse Popular Code Answers by Language