Sql query with date

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';

Source: popsql.com

Similar codes

0 vote193 views1 answer
How to put value in parameters in mysqldataadapter
SQL
5 votes204 views2 answers
Mysqldump password
SQL
6 votes195 views1 answer
Check Table Exists
SQL
0 vote193 views1 answer
How to create a new db from dumb file mysql
SQL
11 votes201 views2 answers
You are using safe update mode
SQL
0 vote181 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote194 views2 answers
Php convert dbf to mysql
SQL
0 vote186 views1 answer
Oracle execute immediate quotes
SQL
0 vote172 views1 answer
Mysql find non alphanumeric characters
SQL
14 votes270 views1 answer
How to export db from mysql
SQL